CountifS

[kets23]

Hi

Would be grateful for any help regarding my excel query. I have a spreadsheet with a number of columns relating to parcels delivered. One of the columns (column C) relates to parcels delivered before 09:00, before 10:00 and before 12:00. There is another column (column E) that shows when these parcels were delivered in the format HH:MM:SS.

I need to establish the number of parcels by type in column C i.e. before 09:00, before 10:00 etc that were delivered on time as stated in column E. this will then tell me the number of parcels with a before 09:00 delivery that were delivered before 09:00 and allows me to work out a % delivered before 09:00. I have tried using Countifs but keep getting an error, formula I am using is as below.

=COUNTIFS(C3:C600,"Before 09:00",E3:E603,"<=09:00:00")

Kind regards

 

[pgc01]

Hi

The 2 ranges must have the same dimension.

=COUNTIFS(C3:C600,"Before 09:00",E3:E600,"<=09:00:00")

 

[kets23]

Hi

Sorry, that was a typo, they do have the same dimensions. 3 to 600.

 

[pgc01]

What is the error that the formula returns?

 

[kets23]

Got it sorted now.