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