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 fu...
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.