temperature weighted average

July 5, 2009 at 06:49:25
Specs: Windows Vista
hello, i have the aggregrate temperature average for a country by month for years 1978 - 2007. How do i calculate this results to yearly temperatur average.


See More: temperature weighted average

Report •

Report •

July 5, 2009 at 20:52:33
If you are trying to get the average temperature for each year, try this...

Your dates are in A1:A10
Your temps are in B1:B10
You have a list of years in C1:C4

Put this array-entered formula in D1 and drag it down to the bottom of your list of years:


Array entered means the formula is entered using Ctrl-Shift-Enter to put {} around the formula.

Report •

Related Solutions

Ask Question