If Then Statement with Dates, Then Counting

Microsoft Microsoft excel 2007 (pc)
March 22, 2012 at 20:36:30
Specs: Windows 7
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!

See More: If Then Statement with Dates, Then Counting

March 23, 2012 at 17:41:08
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:


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

Report •

March 23, 2012 at 19:21:50
Sorry, I meant E14:E113. And I'm using Excel 2007.

Thanks for the solution!

Report •
Related Solutions

Ask Question