Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct assistance - need multiple ANDs and ORs
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 |