| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting more than one condition and multiple ranges
Hi, I am using excel 2003
I have one column where each cell holds "male" or "female" as text. I count each value using countif. I want to further refine my result by reference to another range which where each cell either has a date or is blank. I have tried to use the AND and IF commands and nesting elements but I am not sure of the syntax Can anybody help? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting more than one condition and multiple ranges
Try sumproduct
=Sumproduct(--(C1:C100="female"),--(D1:D10025)) "Sapper" wrote: Hi, I am using excel 2003 I have one column where each cell holds "male" or "female" as text. I count each value using countif. I want to further refine my result by reference to another range which where each cell either has a date or is blank. I have tried to use the AND and IF commands and nesting elements but I am not sure of the syntax Can anybody help? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with two condition from two ranges | Excel Worksheet Functions | |||
| Sum If with two ranges and condition | Excel Worksheet Functions | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Setting multiple ranges to print | Excel Discussion (Misc queries) | |||
| Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
Hybrid Mode
