# 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

#1
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 F113Then 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.

Report •

#2
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