Tried formula below however it just returns zero as an answer no matter
what dates are put in. Any other advice

T. Valko;3359458 Wrote: [color=blue][i]
Try this:

=SUMPRODUCT(--(A2:A10=E1),--(A2:A10=E2),--(D2:D10=1))

--
Biff
Microsoft Excel MVP


"sonic-the-mouse" wrote
in
message
...




--
sonic-the-mouse