automated averaging
automated averaging
(OP)
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?
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





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