Articles

HELP - Excel too many arguments

August 2, 2005 at 06:23:35
Specs: Win2K, 256

This problem is very ridiculous...but I couldn't solve it the way I wanted to.

I am working on a spreadsheet in which every sheet has a daily report. I have to add up the value of each sheet in a separate summary sheet. However, the SUM function adds up only 30 individual cells (1 from each sheet) at a time. What in case of months with 31 days? I get stuck there.

I read this solution in an older post (it did not allow me to re-post since it was in 2003 and there were little chances of someone reading my reply.) but it does not seem to work for me:

"Calculate the 31 days in two different cells (letts say the first 15 days of the month and the last 16) and add those together."

When I do this, the cell gives me a #VALUE error :(. The formula I entered is pasted below. Is it incorrect?

=SUM('1'!B10,'2'!B10,'3'!B10,'4'!B10,'5'!B10,'6'!B10,'7'!B10,'8'!B10,'9'!B10,'10'!B10,'11'!B10,'12'!B10,'13'!B10,'14'!B10,'15'!B10,('16'!B10,'17'!B10,'18'!B10,'19'!B10,'20'!B10,'21'!B10,'22'!B10,'23'!B10,'24'!B10,'25'!B10,'26'!B10,'27'!B10,'28'!B10,'29'!B10,'30'!B10,'31'!B10))

Please help me :(


See More: HELP - Excel too many arguments

Report •


#1
August 2, 2005 at 07:16:25

First of all, you have an additional left paren in your formula right before sheet 16. Do you want that there?

Soylent Green is PEOPLE!!!


Report •

#2
August 2, 2005 at 07:28:20

Why not just do a 3D reference?

=SUM(Sheet1:Sheet31!B10)

That seems simpler to me.

Soylent Green is PEOPLE!!!


Report •

#3
August 2, 2005 at 10:18:23

Maybe I'm on the wrong track here but... Why not have a separate formula in another cell to take the 1st result from 1 to 30 and sumif sheet 31 B10>0.

Report •

Related Solutions

#4
August 2, 2005 at 10:22:19

Oh, I forgot. Use the formula Jennifer gave you, it is much simpler and will do the same thing.

Report •

#5
August 2, 2005 at 13:11:38

"Use the formula Jennifer gave you, it is much simpler and will do the same thing."

How can you go wrong, her last name is SUMN

:)
Bryan


Report •

#6
August 2, 2005 at 14:14:34

LOL :)

Soylent Green is PEOPLE!


Report •

#7
August 2, 2005 at 15:31:05

Its a "sum" function! If it was an average or something, then you'd have to be a bit clever, but really... you could just add the cells rather than SUMming them!

='1'!B10+'2'!B10+'3'!B10+'4'!B10.....

or if you really, really like SUM functions, then terminate the first after 30 parameters, type a "+" and then start another SUM function.

And if you are a complete SUM fancier, then you could nest the SUMs:

=sum(sum(ref1, ref, ref3), sum (ref4, ref5, ref6))


Silliness. It must be summertime.

Tom


Report •

#8
August 4, 2005 at 10:54:16

OR....use the formula I typed so that one doesn't have to go from sheet to sheet to sheet to sheet...and so on.

Soylent Green is PEOPLE!!!


Report •

#9
August 14, 2005 at 22:14:52

Well, thank you everyone.

I'll try nesting (that is what I was trying, but I didn't know one had to add 'SUM' before each nest) once since it's given me so many headaches.

Then I will stick to Jennifer's suggestion - seems to be the best to me :)

A Certan TH: how does not being an ace with excel translate into silliness? There are several things I can do that you cannot even begin! That does not (in my eyes) make you silly.


Report •

#10
August 20, 2005 at 16:35:56

We seem to have crossed wires here: My response was silly, not your question.

Still, always good to note that people know exactly who I am and what I am capable of from just the few words I write here. (Now that IS a silly thing to say)


Report •


Ask Question