sum :Too many arguments for this function

Hi:

I'm trying to sum cells that are not consecutive and I'm getting an error that says "You've entered too many arguments for this function"

I went to help, but I still could not make heads or tails as to why. Are there a limited number of non-consecutive cells that can be entered in a formula?

I hope this is clear.....

Thanks for any help

Regards
Emily

Originally Posted by eparsons

Are there a limited number of non-consecutive cells that can be entered in a formula?

Emily

Short answer, yes.

You can only have 30 arguments in a SUM formula.