Forum Discussion
Heather_DeBey
Jan 16, 2019Copper Contributor
totaling cells from multiple sheets
Hi, I am in no way, shape or form an Excel expert, so I will probably ask more questions than I would ever be able to answer. Sorry if that's annoying! Here's the first. I have a work book with mu...
Heather_DeBey
Jan 16, 2019Copper Contributor
Hi Sergei,
Thanks for trying to help with this. The formula now reads =SUM('[2018DecPaid]2018 Dec Paid'!O37+,'[2019JanPaid]2019 Jan Paid'!O34+,'[2019FebPaid]2019 Feb Paid'!O34) but it is not picking up the data from the second sheet or the 3rd sheet and adding them in to create the running total. Any more ideas?
Thanks,
Heather
SergeiBaklan
Jan 16, 2019Diamond Contributor
Hi Heather,
You don't need "+" in the SUM. In general
=a+b+c and =SUM(a,b,c)
return exactly the same if all of your a,b,c are numbers.
Practically the only difference is what SUM ignores texts, for example
="some" + 10 <= returns error
=SUM("some",10) <= returns 10