View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default CONDITIONAL COUNTING

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.