Count cells if.....

Barney · Jan 9, 2007

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 · Jan 9, 2007

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

Regards,

Peo Sjoblom

Barney · Jan 9, 2007

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 · Jan 9, 2007

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 · Jan 10, 2007

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

Barney