Printable View
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?
Use a pivot table?
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.Quote:
Originally Posted by jdelano
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.Quote:
Originally Posted by Arnoutdv
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.
:p heheheQuote:
Originally Posted by Shaggy Hiker
You got any (Bogus?) Data to illustrate?Quote:
Originally Posted by 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.
The pivot table did the job.