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

=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

Try this:

=SUMPRODUCT(((A1:A30=C1)+(A1:A30=C2))*((B1:B30=D1) +(B1:B30=D2)))

Just group the arguments correctly with parens.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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

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