Hi all,
I am stuck on what feels like a simple problem, but I can't solve it.
I have used a heart rate monitor to record the heart rate of participants running on a treadmill. I programmed the heart rate incorrectly, instead of taking the heart rate every 5 seconds, it took the heart rate after every beat. I therefore have been left with a ridiculously long data sheet, 18394 rows.
What I would like is to take an average heart rate every 5 seconds of elapsed time to best mimic how the monitor should have been set.
I have tried converting the time to seconds and using the following formula:
=AVERAGEIFS(C:C,B:B,">5",B:B,"<10.1")
That works perfectly but I can't drag it down. to try and solve the copy and update formula problem I tried creating 2 extra columns with the 'greater than' and 'less than' values in, for example; 5 - 10.1, 10 - 15.1, 15 - 20.1, and so on. For some reason though using those cell figures as the criteria just comes up with the most annoying result ever.... #DIV/0!
Any ideas? I have attached the first minute of data results, please feel free to take a gander.
Kind regards
Wheats
Bookmarks