You missed the worksheet name on the second date and a few ! characters.


=SUMPRODUCT(--('2007 Discharges'!A4:A500=DATE(2008,1,1)),
--('2007 discharges'!A4:A500<=DATE(2008,3,31)),
--('2007 Discharges'!W4:W500=91%))

Dan the Man wrote:

Forgot to ask. If I put all of my data outcomes on a separate sheet, I know I
need to reference the original sheet where the raw data is coming from. The
original formula that Peo gave me works just fine, however I had difficulty
adding in the additional formula ('2007 Discharges') string when I am using a
different page to reference back. Peo's original formula was:

=SUMPRODUCT(--(A4:A500=DATE(2008,1,1)),--(A4:A500<=DATE(2008,3,31)),--(W4:W500=91%))

I tried adding in without success:

=SUMPRODUCT(--('2007 Discharges'A4:A500=DATE(2008,1,1)),--(
A4:A500<=DATE(2008,3,31)),--( '2007 Discharges'W4:W500=91%))

I'll assume I'm missing something. Again thanks!

Dan

"Peo Sjoblom" wrote:

=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




--

Dave Peterson