Needed: A Quick Integration Routine

[Mike Connolly]

Hi All,
I offten want to get an integrated average value of some time / temperature
data. Time is usually in col 1 and temps are in the other columns. I'd
like to select an arbitrary period of time /temperatures points and find the
intgrated average temperature value. Does someone have a good way of doing
this, perferably with worksheet functions but some VBA code would also work
?

Thanks,
Mike

 

[Bernard Liengme]

Are you using the word 'integration in the mathematical sense?
My site (ExcelTips) has an example of using the trapezoid rule to do a
numerical integration
My book has further examples

 

[Mike Connolly]

Thanks Bernard that's what I was looking for and you have a great site.

Mike