You have entered too many arguments for the function?

[RudeBoy]

I entered this:

=SUM(J7,J11,J15,J19,J23,J27,J31,J35,J39,J43,J47,J51,J55,J59,J63,J67,J71,J75,J79,J83,J87,J91,J95,J99,J103,J107,J111,J115,J119,J123,J127)


Can some one help with is there a limit I need to increase etc etc thanks

 

[BrianJN1]

Re: U have entered too many argumentsfor the function?

On a bit of research it seems that SUM has a limit of 30 references. A few instances that I've seen get around this, such as:
= sum(A1,A2,....A29) + sum(A30,A31.... A59) +....
Obviously if you have consecutive cells in a range then link the group with a colon, A1:A10.

Does that help?

 

[footoo]

Re: U have entered too many argumentsfor the function?

=sumproduct($j$7:$j$127*(mod(row($j$7:$j$127),4)=3))

 

[JoeMo]

Re: U have entered too many argumentsfor the function?

You could use this array formula. Be sure you enter it using ctrl+shift+enter, not just enter. If entered correctly you will see curly braces around the entire formula in the formula bar.

=SUM(IF(MOD(ROW($J$7:$J$127),4)=3,$J$7:$J$127))

 

[RudeBoy]

Re: U have entered too many argumentsfor the function?

Yes that worked Fantastic

=SUM(J7,J11,J15,J19,J23,J27,J31,J35,J39,J43,J47,J51,J55,J59) + SUM(J63,J67,J71,J75,J79,J83,J87,J91,J95,J99,J103,J107,J111,J115,J119,J123,J127)

 

[BrianJN1]

Re: U have entered too many argumentsfor the function?

Give those other two proposals some consideration too as they require less work (and avoid that you may inadvertently miss a value).