CONDITIONAL COUNTING

[Guest]

I am trying 2 figure out a formula like a conditional sum but for counting
and not summing up.

Tried:
{=COUNT(IF($A$2:$A$7="A",IF($B$2:$B$7>2,$B$2:$B$7,0),0))}
but its not working.

Thanx in advance.

 

[Guest]

try:
=SUMPRODUCT(--($A$2:$A$7="A"),--($B$2:$B$7>2))

 

[Bernard Liengme]

This
=SUMPRODUCT(--($A$2:$A$7="A"),--($B$2:$B$7>2))
will count how many values have an A-cell value of "A" and a B-cell value >2
while
=SUMPRODUCT(--($A$2:$A$7="A"),--($B$2:$B$7>2),$B$2:$B$7)
will sum those values
For more details, see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

This also does the count:
{=SUM(IF((A1:A7="A")*(B1:B7>2),1,0))}
or more simply
{=SUM(((A1:A7="A")*(B1:B7>2)))}
best wishes