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

"Dan the Man" wrote:

I have 2 distinct tabs on my spreadsheet. One called "New Rules Sample", and
the other called "QA Data Sheet". I'm trying to capture all of my relevant
data on the QA Data tab, and so far so good. I have a variety of information
there. However, when I attempted to capture the 2 following bits of Data (and
tested my formula) I could not make it work. The formula seems to work well
with words (e.g. "Refusal"), but not so well with numerical values. Any
suggestions? Below are the 2 "Array" formulas I'm trying to make work with
respect to reporting the frequency (Row H) of BAC levels 0.16% or greater:

=SUMPRODUCT((YEAR('New Rules
Sample'!T4:T3500)=2007)*(ISNUMBER(SEARCH({"=0.16" },'New Rules
Sample'!H4:H3500))))

=SUMPRODUCT((TEXT('New Rules Sample'!T4:T3500,"mmm yy")="Jan
07")*(ISNUMBER(SEARCH({"=0.16"},'New Rules Sample'!H4:H3500))))

Btw, Roger has been of incredible help to me, but I didn't want to tax him
further, so I'm putting this problem out to the group, lol!