View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carol Carol is offline
external usenet poster
 
Posts: 115
Default Count data in one column indicated by data in another column

Column A holds "X" or "" (blank). Column B holds "1", "2", or "3".
I need to count the number of 1s, 2s, and 3s, in column B when the cell in
column A is blank.

I've tried several variations of IF, AND, & COUNTIF - can't get anything to
work. Have also tried many variations of SUMPRODUCT found in other posts.
None are working for me.

Can you please help? Is there a way to do this?
Thank you!
--
Carol