Count cells if.....

[Barney]

I want to count cells in a column only if they are greater than zero and if
they are three less than a specified constant cell.

Thanks,

Barney

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A100>0),--(A2:A100=B2-3))

Regards,

Peo Sjoblom

 

[Barney]

I have no idea what goes into the formula where the "--"s are but when I put
nothing there it does not work.

Barney

 

[Gord Dibben]

Barney

-- is two hyphens and both sets need to be in the formula as Peo wrote it.

Known as a double unary.

For more on SUMPRODUCT see Bob Phillips' site.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Gord Dibben MS Excel MVP

 

[Barney]

Thanks Peo and Gord.. That works perfectly. I am sorry I did not understand
at first.

Barney