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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History