I cannot see why your formula works at all. The one below should work for
you. If column S is in minutes already then you should not need to use the
TIME function.

=SUMPRODUCT(($I$4:$I$400=3)*($S$4:$S$400<=45))



"Denise" wrote in message
...
I am using the following formula:

=SUMPRODUCT(--(I4:I400="3"),--(S4:S400<=TIME(0,45,0)))

The spreadsheet that I have has different floor numbers (3-7) that are in
column I. I need to count how many had times of < = 45 minutes on each
floor. This is the formula that I got from someone here.

My numbers are not matching. So far for this month for admissions to the
3rd floor that are <= 00:45 I have 7, the formula is showing 4.

Can anyone help me!!! The only reason that I noticed this is that we have
had 33 admissions to the 3rd floor. All of the times that this formula is
giving me do not add up to 33.

TIA.