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