AVERAGEIFS with time as criteria

[DocCod]

I’m trying to get an average of data in column C based on the corresponding time range in column A. The input in columm A is time. So for example, say I want the average between 09:00:00 and 09:30:01. In Column N2 and NO I put those 2 times respectively.



The formula I made was the following:

=AVERAGEIFS(C2:C17190;A2:A17190;A2:A17190>=N2;A2:A17190;A2:A17190<O2)

This however returns a DIV/0 error. I don’t know what I’m doing wrong. I’ve been working on this for days and I can’t seem to get it right. Help would be greatly appreciated.

 

[Phuoc]

Try this:

=AVERAGEIFS(C2:C17190;A2:A17190;">="&N2;A2:A17190;"<"&O2)

 

[DocCod]

Try this:

=AVERAGEIFS(C2:C17190;A2:A17190;">="&N2;A2:A17190;"<"&O2)

Whoa it worked! Thank you so much! I'm fairly new to Excel, do you always need to add the:

">="&

in order for it to work in a formula like that?