View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default formula on counting

try

=sumproduct((a2:a22="John")*(c2:c22="cxl")*1)

--
Don Guillett
SalesAid Software

"Michael A" wrote in message
...
Hello, could someone please help me with a forumula. Im not sure what
function to use to get this to work right.

I need a formula that will count how many entries in column C say "CXL".
But
I only want it to count on the rows that have "John" in column A. Im not
sure
how to do this. Thanks!