Been playing about with the SUMPRODUCT formula and input

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

The < signs appear to be returning the correct answer! So I fully
understand the formula can you explain what the "--" signifies,
please?

s-t-m
sonic-the-mouse;3360456 Wrote:
Checked all dates and they are true dates in excel, however SUMPRODUCT
is still returning zeros.

In F1 I am using

=COUNTIF(a2:a10,"="&E1)-COUNTIF(a2:a10,""&e2)

to return the number of incidents between the dates, but still cannot
work out how to find out how many of those incidents have taken longer
than 3 days to process. Any advice?

s-t-m




--
sonic-the-mouse