Hello,
I use Microsoft Excel 2007. As shown in the attached file, Column A contains years (from 1895 to 2006), Column B contains months, and Column C contains temperature. I need to calculate the average temperature for each year. How can I do that?
Thanks.
I have not had tiome to look at your file, but take a look at the AVERAGIF() and AVERAGEIFs() functions for this
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FortJames(1).xlsx
If I wanted the average for all the years I'd do a pivot table like this but if you only want one years data you could do what I've done in the top of sheet 1 using an averageif statement
Happy with my advice? Click on the * reputation button below
Based on your table, create a list of dates as shown below....
F2=AVERAGEIF($A$2:$A$1343,E2,$C$2:$C$1343) copied down
Hi,
find the attached file with If condition & Average if function
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks