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