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

"FARAZ QURESHI" wrote:

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$72,$B$2:$B$7, 0),0))}
but its not working.

Thanx in advance.