Microsoft Microsoft excel 2007 (pc)

In Excel, I have coded each entry with a number between 1-10 (column AN14:AN113) and am trying to find the percentage that each number (1, 2, 3, etc.) occurs within a calendar year date range (01/01/11-12/31/11) within the column (E12:E113). Just need help coming up with the formula...Thanks!

I'm a bit confused. Your number codes are in AN14:AN113 but your dates are in E12:E113.

That's 2 less rows of dates than numbers. Is that correct?

What version of Excel are you using?

If it's 2007 or later, try this:

Add another column (often called a Helper Column, which you could hide) to extract the Year from the dates in E12:E113.

e.g. in F12 enter =YEAR(E12) and drag it down to F113

Then you can use this formula for your percentages:

e.g. for the number 1:

=(COUNTIFS($AN$12:$AN$113,1,$F$12:$F$113,2011))/COUNTIF($F$12:$F$113,2011)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Sorry, I meant E14:E113. And I'm using Excel 2007. Thanks for the solution!

Ask Your Question

Weekly Poll

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History