| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct assistance - need multiple ANDs and ORs
Thank you Bob and RD. Your suggestions worked!
-Heidi "Heidi" wrote: We are trying to count the number of rows whe (1) the date is one of two dates (date1 OR date2) AND (2) a column is one of two values (value1 OR value2) I am familiar with using sumproduct to do either AND (*) or OR (+), but am not sure how to approach mixing the two. Does anyone have any suggestions? Thanks, Heidi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
