This is for row 2...

=SUMPRODUCT((MOD(COLUMN(2:2), 2)=0)*(2:20))
--
HTH...

Jim Thomlinson


"whygh" wrote:


Hell everyone,

I want to count the cells of column, the condition are
1. column Number is even. such as Column D,F,H...
2. the value if cell is greater then zer0.

How to write the formula , I have no idea.

Thanks


--
whygh
------------------------------------------------------------------------
whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679
View this thread: http://www.excelforum.com/showthread...hreadid=493965