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?
It looks like this
That's Excel online
For the Spanish version the formula is
=SUMA('1'!E47;'2'!E47;'3'!E47)