Forum Discussion

moringa fresh's avatar
moringa fresh
Copper Contributor
Apr 25, 2018

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...
Excel Online
Formulas & Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 26, 2018

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)
  • moringa fresh's avatar
    moringa fresh
    Copper Contributor
    Apr 30, 2018

    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?

     

    • moringa fresh's avatar
      moringa fresh
      Copper Contributor
      Apr 30, 2018

      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. 

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 01, 2018

        My guess for Spanish version you shall use semicolons, not commas.

         

        Anyway, please open attached file and check how the formula looks in E44

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 30, 2018

      It looks like this

      That's Excel online

      For the Spanish version the formula is

      =SUMA('1'!E47;'2'!E47;'3'!E47)
    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      Apr 30, 2018

      Try this formula.  I think Sergei already created this one as well, but it seems to work for me....  I just tried it in an Excel Online mockup and it worked without issue (I had 5 worksheets named 1,2,3,4 & 5):

       

      =SUM('1:5'!E47)

       If you can export your workbook from Excel online and provide a non-sensitive example file it may help to solve your issue.  There may be something happening that is not apparent based on your description that would be easier to find with an example file.

Resources