how can i have more than 30 arguements in a SUM
What's your actual formula?
"RobG2007" wrote:
mine reads =SUM(1 arguement)-(30 arguements)+(30 arguements )
but it says i have to many , is this wrong
"Pete_UK" wrote:
Try something like this:
=SUM(first_30_arguments) + SUM(second_30_arguments) etc
Hope this helps.
Pete
On Jul 25, 5:02 pm, RobG2007
wrote:
i want to add more than 30 different values together from different cells but
SUM tells me i can only have 30 is there an easy way round this thanks
|