Forum Discussion
sum of same cell, from many different sheets on excel online.
I am having trouble using the formula I have found for excel, on excel online to sum the same cell from 30 different sheets.
I tried: =SUM(1!E47,2!E47,3!E47)
what am i doing wrong? does this function work online?
thank you
7 Replies
Yes, it works with Excel Online if your sheets have names "1","2" and "3".
=SUM('1'!E47,'2'!E47,'3'!E47) or =SUM('1:3'!E47)HMM...I tried : =SUM('1'!E47, '2'!E47)
and I get this response #NOMBRE? (My computer is in spanish, I assume it would be #name? in english)
my formula has spaces because it also didnt work without spaces. Any other ideas?
I did find that a few things are different with the spanish version. As of now I have realized I should put the formula like this:
=SUMA(Hoja1!B5, Hoja2!B5)
now its not giving me an error indication, however, it is summing up 0 and it should show me a large number with just the 2 cells being added.
Hi
Try this one =SUM(Sheet1:Sheet2!B1)
Change the range as per your requirement.
