| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting multiple conditions to return a figure from multiple cells
Hi,
A B 1 Male 2 Male 21/06/71 3 Female 08/11/68 # 4 Male 11/04/70 5 Female 6 Female 19/10/69 # I want to count the number of females in A with a date against their name in B and return as a number. =Countif(A1:A6,"Female") returns 3. How can I tell excel to look at those 3 cells(without knowing their references) and count those with a date in the adjacent cell ie 2? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting multiple conditions in one cell | Excel Worksheet Functions | |||
| return a result from multiple conditions. | Excel Worksheet Functions | |||
| How do I return a value based on multiple possible conditions? | Excel Worksheet Functions | |||
| Multiple conditions and multiple return values | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
Threaded Mode
