automated averaging

[ACtrafficengr]

IS there an "AVERAGEIF" function, or a reasonable facsimile thereof?

I have a weeks worth of time-stamped data. Is there a way to average all the data for say, 15:00 hrs?

"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928

"I'm searching for the questions, so my answers will make sense." - Stephen Brust

 

[MrMask]

You could make a pivot table with averages and select the specific time you want.

 

[MrMask]

you could "DAVERAGE" as well:

DAVERAGE(database,field,criteria. You can also use Boolean operators to create multiple criteria

 

[Denial]

How about SUMIF divided by COUNTIF?