Summing a column

A

Al Ramirez

Example: I have data in column A1 through A95 and I only want to sum every
other cell how do I do that without getting an error message. The sum cell
would be A97.
Al
 
D

Domenic

To sum every other cell, starting with the first one, try...

=SUMPRODUCT(--(MOD(ROW(A1:A95)-ROW(A1)+0,2)=0),A1:A95)

If you want to sum every other cell, starting with the 2nd cell, change
+0 to +1.

Hope this helps!
 
A

Ashish Mathur

Hi,

Try this. In cell A 97 array enter (Ctrl+Shift+Enter)

SUM(IF(MOD(A1:A95,2)=0,A1:A95))

This will sum up the even rows in the range. To sum up odd rows, replace
the 2 in the MOD function with 1

Regards,
 
Top