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.

thanks


See More: temperature weighted average

Report •


#1
Report •

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

Example:
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:

=SUMPRODUCT((YEAR($A$1:$A$10)=C1)*($B$1:$B$10))/SUM(1*(YEAR($A$1:$A$10)=C1))

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


Report •

Related Solutions


Ask Question