Ask Your Question
0

=sum('Anonymous:Wyatt,Virginia'!f45:f45)

asked 2018-09-18 22:08:07 +0100

bgnat gravatar image

This is an excel formula adding F45 from all worksheets from anonymous to Wyatt (about 30) and returning the total, but will not work in Libre. Can someone help me?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-18 22:19:36 +0100

Calc is much more consistent here: it defines first range cell, then last range cell, and both cells just use full address:

=SUM(Anonymous.F45:'Wyatt,Virginia'.F45)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-18 22:08:07 +0100

Seen: 18 times

Last updated: Sep 18 '18