Ooops...misread your post:
=SUMPRODUCT((A1:A5="B OP")*(C1:C5>=D1)*( C1:C5<=D2))
D1 - 01/04/05
D2 - 17/04/05
Regards
JG
Ooops...misread your post:
=SUMPRODUCT((A1:A5="B OP")*(C1:C5>=D1)*( C1:C5<=D2))
D1 - 01/04/05
D2 - 17/04/05
Regards
JG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks