Hi Dan

The problem is that you have both text and numeric in Column H, where
the word Refusal appears.
Use the following formulae

=SUMPRODUCT((YEAR('New Rules Sample'!T4:T3500)=2007)*
('New Rules Sample'!H4:H3500=0.16)*(ISNUMBER('New Rules
Sample'!H4:H3500)))

=SUMPRODUCT((TEXT('New Rules Sample'!T4:T3500,"yyy mm")="Jan 07")*
('New Rules Sample'!H4:H3500=0.16)*(ISNUMBER('New Rules
Sample'!H4:H3500)))

--
Regards

Roger Govier


"Dan the Man" wrote in message
...
Max I think Excel hates me, lol! I entered the data EXACTLY as you
suggested
(into the proper cells and not as an Array), and when I went to taste
the
variables in Rows T and H it wouldn't work. It's odd, because the
other
variables you saw on my "QA Data Sheet" tab (the text) worked
perfectly with
the formulas I was given thanks to Roger. These numerical references
however
just don't want to cooperate. I felt stupid posting again after all
the time
and effort you put into this for me...................

Dan

PS: Thank you very much for your time!

"Max" wrote:

The prob was that there was a mixture of numbers and text within:
'New Rules
Sample'!H4:H3500. This can be treated via "adding" another condition
into the
formula to ensure that only numbers would be involved (ignore text),
ie:
ISNUMBER('New Rules Sample'!H4:H3500)

In QA Data Sheet,

Put instead in B11:
=SUMPRODUCT((YEAR('New Rules Sample'!T4:T3500)=2007)*('New Rules
Sample'!H4:H3500=0.16)*(ISNUMBER('New Rules Sample'!H4:H3500)))

Put instead in B12:
=SUMPRODUCT((TEXT('New Rules Sample'!T4:T3500,"mmm yy")="Jan
07")*('New
Rules Sample'!H4:H3500=0.16)*(ISNUMBER('New Rules
Sample'!H4:H3500)))

Note that I've also changed in the above, back to using: =0.16
from what I see in your descriptions in A11 & A12

One last comment. I noticed you had array-entered all your
SUMPRODUCTs.
SUMPRODUCT doesn't require array-entering (CSE) unless TRANSPOSE is
used
within. Just normal ENTER will do.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dan the Man" wrote:
Max you and Roger have been so very helpful tonight. I am
appreciative. I
still can't seem to make the formula work when I manipulate the
data in the 2
applicable Rows (H and T). I sent you the file on email if you have
an
opportunity or willingness to look at it. If not I'll understand.

Best,

Dan