View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lori_tig
 
Posts: n/a
Default How do I compare two values to calculate a total?

I'm trying to compare two columns, and count it as "1" in a total, if both
cells meet individual criteria, to see if we have enough players for a
softball game.

Column D states whether the player is M of F, and column G lists a Y or N as
to whether that player is available for that specific game. So, I want to
count all the cells where D="F" and G="N", but only when both conditions are
true. This is for range 2:22 in both columns. Seemed simple enough when I
started, but I'm doing something wrong.