Summing a column
 

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

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!

In article ,
"Al Ramirez" <Al wrote:

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

One way ..

Try in A97: =SUMPRODUCT(--(MOD(ROW(A1:A96),2)=1),A1:A96)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Al Ramirez" <Al wrote in message
...
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

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,

"Al Ramirez" wrote:

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