Averaging Data Logger Output from Seconds to Minutes

**Ben Mayo** · 11-14-2012, 10:48 AM

Dear Excel Forum Experts,

I have a data logger which produces a reading every second.
I would like to be able to produce an average of each minute in the adjacent columns.

Please see the attached file, and many thanks for any help you are able to give.

Ben

**martindwilson** · 11-14-2012, 11:29 AM

in e2
=ROUND(SUMPRODUCT(--(FLOOR($A$2:$A$1000,1/1440)=D2)*$B$2:$B$1000)/60,0)
i used round because the actual averages are
19.71666667
39.71666667
82.46666667