Forum Discussion
moringa fresh
Apr 25, 2018Copper Contributor
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...
Gourab Dasgupta
Apr 26, 2018Iron Contributor
Hi
Try this one =SUM(Sheet1:Sheet2!B1)
Change the range as per your requirement.