[RESOLVED] Excel Weird Average Question

[Shaggy Hiker]

I've almost put this together, but figured I'd ask here. It's mostly just a set of functions, most likely.

I have a spreadsheet that has these columns:

Month, Unimportant,Year,Blah,Blah,Blah,Target

What I'm trying to do is average Target for every month/year combination.

AverageIf gets me close, but I don't know what to put into the criteria, or if this isn't the right approach.

Any suggestions?

[Arnoutdv]

Use a pivot table?

[jdelano]

Okay, I'll bite. Is the question weird or just average?

[Shaggy Hiker]

Okay, I'll bite. Is the question weird or just average?

Neither, it's the subject line. I couldn't think of what to put there that would be useful.

[Shaggy Hiker]

Use a pivot table?

I was going to say that I couldn't, but now that I think more about it, I realize that I was confusing two different projects. That might very well work.

I haven't used Excel very much in many years, and I really haven't used pivot tables much, but the ultimate goal is to be able to create a line graph of the average for each month, where the month and year are in two separate columns. The graph is the goal, but the pivot table would create the data for the graph.

[jdelano]

Neither, it's the subject line. I couldn't think of what to put there that would be useful.

hehehe

[Zvoni]

I've almost put this together, but figured I'd ask here. It's mostly just a set of functions, most likely.

I have a spreadsheet that has these columns:

Month, Unimportant,Year,Blah,Blah,Blah,Target

What I'm trying to do is average Target for every month/year combination.

AverageIf gets me close, but I don't know what to put into the criteria, or if this isn't the right approach.

Any suggestions?

You got any (Bogus?) Data to illustrate?

[Shaggy Hiker]

Month Day Year OtherColumn ColumnToAverage
1 1 2000 Stuff 7
1 2 2000 Stuff 8
1 3 2000 Stuff 5
...
2 1 2000 Stuff 2
2 2 2000 Stuff 6
2 3 2000 Stuff 11



That's roughly how it's laid out. Day is being ignored, the objective is to come up with a single value (the average of that last column) for each month/year combination.

[Shaggy Hiker]

The pivot table did the job.