Opv
05-05-2013, 06:53 PM
I have a simple AVERAGE formula which averages all data in Column C. Each row of data includes both the date (Column A) and time (Column B) for that particular entry. What I am wanting to do is to be able to include several averages, i.e., the average of the data for the AM hours, the average for the PM hours and an overall average.
The Time range is $B$4:$B$100 and is formatted as 8:30 AM, 9:40 PM, etc. The data range to which the various averages will be applied is in $C$4:$C$100.
I've experimented with SUMPRODUCT and AVERAGEIF; however, I can't seem to the formula to apply a criteria such that it tests for the HOUR being <12 vs >=12. Any help will be greatly appreciated.
The Time range is $B$4:$B$100 and is formatted as 8:30 AM, 9:40 PM, etc. The data range to which the various averages will be applied is in $C$4:$C$100.
I've experimented with SUMPRODUCT and AVERAGEIF; however, I can't seem to the formula to apply a criteria such that it tests for the HOUR being <12 vs >=12. Any help will be greatly appreciated.