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