Try:
=SUMPRODUCT((A1:A5="B")*(B1:B5="op")*(C1:C5>=D1)*(C1:C5<=D2))
where D1 is 01/04/05
and D2 is 17/04/05
HTH
JG
Try:
=SUMPRODUCT((A1:A5="B")*(B1:B5="op")*(C1:C5>=D1)*(C1:C5<=D2))
where D1 is 01/04/05
and D2 is 17/04/05
HTH
JG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks