COUNT Formula with IF(s)

[garypea123]

Hi,

I am trying to write a formula in say D3 which will look at C3 time and then tell me how many agents were on in that time.

For example the result for D3 would be 4 and the result of D4 would 5.

I think maybe a match and count formula or something? Or maybe something more simple. Trying to get back into Excel again and mind is blank

 

[Fluff]

Maybe

=countifs(f:f,c3)

 

[garypea123]

THank you, as normal I look at something and try over complicate it

This makes absolute perfect sense and is much more easy

 

[Fluff]

You're welcome & thanks for the feedback.