Thread: How do I set up a formula to add column a if column b = cell c1?
View Single Post
  #37   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Question?? Question?? is offline
external usenet poster
  
Posts: 1
Default How do I set up a formula to add column a if column b = cell c
I am looking for something similar. I have 2 columns that I need to count

A B
8 Yes
2 Yes
6 No
4 Yes

I need to count the number of Yes's in column B for each number, so lets say
I need the number of Yes's for 8. How can I do that? Is it even possible? I
tried using countif but I can only get it to use just the one column and I
need it to filter both.

Thanks for your help!

Reply With QuoteReply With Quote