More than 30 arguements in a cell

[ragan]

I have a spreadsheet set up that cannot be altered and I am trying to sum every other cell in a column with 80 rows. There is a max of 30 arguments allowed - i.e., =sum(a1,a3,a5,...). How do I solve this?

 

[RoryA]

You can use:
=SUMPRODUCT(--(MOD(ROW(A1:A80),2)=1),A1:A80)
to sum the odd row numbers.

 

[Jonmo1]

The simplest solution would be to not use Sum...

Try

=A1+A3+A5+A7.....

Standby for a more clever solution without having to type each cell reference.

Is it literally every other cell, beginning with A1? Or is that a simplified version of actual goal?

 

[ragan]

Rorya,

Okay, here is my function - =SUMPRODUCT(--(MOD(ROW(H58:H123),2)=1),H58:H123)

To test the formula, I have only two values in the columns, I will fill the rest once I fix this issue:

In line 62 I have a total of 7
In line 63 I have a total of 44.5

The function you gave me returns 44.5. I have tried everything, but i cannot change it to return 7, can you help me?

 

[Jonmo1]

=SUMPRODUCT(--(MOD(ROW(H58:H123),2)=1),H58:H123)

The bold red 1 makes it sum ODD rows
Change that to a 0 to make it sum the EVEN rows