View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris
 
Posts: n/a
Default counting cells in two columns that have the same results

I'm trying to come up with a formula that would give me a count of a yes/no
combination in two different columns like below:

K L
1 Member Approved
2 y y
3 y n
4 n y
5 y y

where I can get a count of the "Y" in column K that are also "Y" in column
L, in other words, the members who are also approved. I've tried stringing
two countif formulae together, but can't seem to get that to work. Any
suggestions?