IF Function HELP!!!!!!!!!

[tulsa]

I collect data daily from 2005 to Present, when I collect the data I get the Date and the Price. I would create a simple table the 12 months by the year and have to manually type =average(cells) tooo many times. I have been looking online to figure out how I could do this easier, but I can't seem to get a simple answer.

So if I have column A: And Column B has the numbers for that day. Can someone help me figure out a simple IF function or something that would give me the averages for each individual month?

1/2/2009
1/5/2009
1/6/2009
1/7/2009
1/8/2009
1/9/2009
1/12/2009
1/13/2009
1/14/2009
1/15/2009
1/16/2009
1/20/2009
1/21/2009
1/22/2009
1/23/2009
1/26/2009
1/27/2009
1/28/2009
1/29/2009
1/30/2009
2/2/2009
2/3/2009
2/4/2009
2/5/2009
2/6/2009
2/9/2009

[Pete_UK]

I don't think anyone will be able to help you until you amend that title - read the Forum Rules at the top of the screen to find out why. Your title should describe what you want to achieve.

Pete

[XOR LX]

Hi,

A Pivot Table would be really ideal for this.

Regards

[Milyssa510]

Hi Pete,
You could try using AverageIF function - If you break out the month and year and concatenate the month and year in a column right next to your date, then use AverageIf.

Assuming your first row of data in in Row 3 and your dates in are in column A, price in column B, put the formula to concatenate in column C (=+MONTH(A3)&"-"&YEAR(A3) ) and the averageif (=+AVERAGEIF(C:C,C3,B:B)) in column D, then drag this down to alll rows and your average will populate for that month on each row. If you only wanted to see the average on the last row of data for that month then you could incorporate an IF statement. Hope this helps!

[Pete_UK]

Hi Pete, ...

I don't need to know how to do it !!

Pete

[Milyssa510]

My applogies I ment to put Hi Tulsa, which I didnt realize until after I posted - I didnt mean to insult you.

[Pete_UK]

No insult taken. Let the OP change the title before you offer any more help.

Pete

[martindwilson]

mods please the op has reposted here http://www.excelforum.com/excel-form...al-months.html
instead of changing this thread, a genuine mistake i think

[FDibbins]

Thanks Martin. I will close this thread now, You can continue on you're new thread. For future reference, all you need to do is change the thread title, no need to create a new thread...

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you