Formula help needed desperately quickly!

[sean69]

Hi,
I need some help with creating a formula in Excel. Can someone tell me if there is a cap on how many cells you can tell a cell to pick up in a formula? I’m trying to create a formula in a cell in the front sheet of a workbook that picks up the corresponding cells in back sheets in the same book, but as soon as I’ve entered 30 an error message comes up saying ‘you have entered too many arguments for this function’…….
Can anyone tell me how I can enable it to let me add more?

 

[JamieDuncan]

=SUM((SUM(A12,B12,C12,D12,E12,F12,G12,H12,I12,J12)),(SUM(A13,B13,C13,D13,E13,F13,G13,H13,I13,J13)),(SUM(A14,B14,C14,D14,E14,F14,G14,H14,I14,J14)),(SUM(A15,B15,C15,D15,E15,F15,G15,H15,I15,J15)),(SUM(A16,B16,C16,D16,E16,F16,G16,H16,I16,J16)),(SUM(A17,B17,C17,D17,E17,F17,G17,H17,I17,J17)),(SUM(A18,B18,C18,D18,E18,F18,G18,H18,I18,J18)),(SUM(A19,B19,C19,D19,E19,F19,G19,H19,I19,J19)),(SUM(A20,B20,C20,D20,E20,F20,G20,H20,I20,J20)),(SUM(A21,B21,C21,D21,E21,F21,G21,H21,I21,J21)))

this adds together 100 cells, technically its possible to use this to sum 900 cells this way. Maybe its possible to go deeper though!

 

[sean69]

thanks to everyone for advice, got it sorted now.

 

[jolivanes]

Hi sean69.
Wouldn't you like to share your fix with other people who'd have the same or similar problem?
Looking forward to seeing your fix.
Thanks and Regards.
John