View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
whygh[_4_] whygh[_4_] is offline
external usenet poster
 
Posts: 1
Default Count multiple condition


Thank you guys!

I tried

"=SUMPRODUCT((MOD(COLUMN(2:2), 2)=0)*(2:20))"

it works.

AS to
"=SUMPRODUCT((MOD(COLUMN(D2:K20),2)=0)*(D2:K20 ))" ,
It is the sum of the even columns and values greater than zero. I also
use it .

Vivian


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