Forum Discussion
How to count average in certain time range
Hello Excel wizards, I'm not the best with Excel so I would like to ask for help with this problem I have. I have 8 hours of measurement data and I want to know 30 minute averages in certain ...
Suppose you have 12:00 in cell A1 and 12:30 in B1 and your data starts on row 3:
=AVERAGEIFS($B$3:$F$100,A3:A100,">="&A1,A3:A100,"<="&B1)
=AVERAGEIFS($B$3:$F$100,A3:A100,">="&A1,A3:A100,"<="&B1)
Hi Jan,
Thanks for your help!
I used your formula but it returns #DIV/0!.
I tried to find an explanation for this but I can't get it work...
Any tips would be highly appreciated!
In that example I was trying to calculate it only for column B.
- What is in the cells in column A *precisely*? If you change their number format to general, what do they show?
