Basically I have 2 columns the first column has years in it & the second has random letters.
Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009
And going down the Second Column it reads:
Note: This is just a segment of the data table.
What i need is formula that will answer the following question, when a applied to the ranges in column 1 & 2.
Question: In 2009 'A' Occurred...(FORMULA IN HERE) Times.
Question: In 2009 'B' Occurred... (Formula Here) Times.
I've tried everything - COUNTIF & SUMPRODUCT. I also have Excell 2003. Please help me this is driving me insane!
May 13, 2009 6:59 AM
May 13, 2009 10:01 PM