Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
Can Excel calculate populate table using row/column values & calc's on other sheet? | Excel Discussion (Misc queries) | |||
total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) | |||
How do i compare data fields and assign values? | Excel Worksheet Functions | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions |