=SUMPRODUCT(--(A2:A50=DATE(2008,1,1)),--(A2:A50<=DATE(2008,3,31)),--(C2:C50=91%))


for quarter1 2008 greater than or equal to 91%

change the cell refs to fit your own




--


Regards,


Peo Sjoblom

"Dan the Man" wrote in message
...
Column A Column B Columm C

Row 3 Aug 1, 2008 Joe Jones 91%
Row 4 Mar 15, 2008 Mary Doe 86%

Lookinig for a formula to provide me with a statistical information by the
four quarters of the yeaer(e.g. quarter one would be Jan 1-March 30,
2008).
What I want to anaylyze is a percentage breakdown. For example, I want to
know how many individuals show outcomes at 91% or more. Thus, the formula
might generate an outcome that tells me that 15 of the total individuals
on
my spreadsheet scored at 91% or greater.

I'll also have to breakdown other percentage parameters (e.g. outcomes
between 75-89%, etc), however once I get the outline of a formula I should
be
able to do the rest. I'm thinking I need an array formula, but I just
wasn't
sure how to get what I wanted. Thanks much in advance.

Dan