You're welcome - thanks for feeding back.

Pete

On Feb 24, 2:16*am, Noetic76
wrote:
Thanks Max and Pete, that's done the trick



"Pete_UK" wrote:
Try this:

=SUMPRODUCT((A1:A10="ENT")*(B1:B10=--"8:00:00")*(B1:B10<=--"16:00:00"))

Or, you could put ENT in C1, the start time in D1 and the end time in
E1 and use:

SUMPRODUCT((A1:A10=C1)*(B1:B10=D1)*(B1:B10<=E1))

Hope this helps.

Pete

On Feb 24, 1:17 am, Noetic76
wrote:
hi, I have a table that looks something like this:

Unit * *Time
ENT * *10:36:00
ENT * *01:15:00
EMU * 12:36:00

etc etc.

I need to be able to calculate number of entries per unit per time range, eg
the numbers of times ENT occurs between 8am and 4pm.

Any suggestions?
Thanks, Ruth

.- Hide quoted text -

- Show quoted text -