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

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:C4Put 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.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History