=SUMPRODUCT(--((C1:C20=date1)+(C1:C20=date2)),--((D1:D20="value1")+(D1:D20="value2")))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Heidi" wrote in message
...
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