Adding Only Positive Numbers

P

PMC527

I have been looking around and found solutions to adding only positive
numbers in a range however, if I am trying to add numbers that are not
next to eachother but actually every other cell, everytime that I
select the 4 cells a "," is added between each messing up my formual.
ie. =SUMIF(H3,J3,L3,N3,>0), how would I do that only adding the numbers
that are positive?

Thanks for the help, hopefully I explained it good enough.
 
B

Bob Phillips

=SUMPRODUCT(--(MOD(COLUMN(H3:N3),2)=0),--(H3:N3>0),H3:N3)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
C

CLR

=SUM(IF(H3>0,H3,0)+IF(J3>0,J3,0)+IF(L3>0,L3,0)+IF(N3>0,N3,0))

Vaya con Dios,
Chuck, CABGx3
 
Top