i need help on something asap.

[nnos]

Hello,

So i have this issue, i want to use averageifs function to do my calculation.

On my excel i have a column for year from 1985 to 2011, and a row for months from Jan to Dec.
so i want to use averageifs to calculate the data i have. I want it to take the average of a month within that year.

so for example

year: months Data
1985 Jan 123
1986 Feb 1312

how can i approach this? anything would help.

 

[vavs]

You may want to try a pivot table. Use the year followed by the month and then use the average function in the data area.

This way you can select a year, group of years and you can even group the months into quarters if necessary.

 

[T. Valko]

Hello,

So i have this issue, i want to use averageifs function to do my calculation.

On my excel i have a column for year from 1985 to 2011, and a row for months from Jan to Dec.
so i want to use averageifs to calculate the data i have. I want it to take the average of a month within that year.

so for example

year: months Data
1985 Jan 123
1986 Feb 1312

how can i approach this? anything would help.

Something like this...

=AVERAGEIFS(C:C,A:A,1985,B:B,"Jan")

That will average column C where column A = 1985 and column B = Jan.

Better to use cells to hold the criteria:

E1 = 1985
F1 = Jan

=AVERAGEIFS(C:C,A:A,E1,B:B,F1)