Maybe this:

=SUMPRODUCT(--(DUMMY REPORT'!$D$2:$D$3273="DUMMY LOCATION"),--('DUMMY
REPORT'!$A$2:$A$3273="DUMMY CODE"),--('DUMMY REPORT'!$E$2:$E$3273)3)

HTH,
Paul

--

"jeannie v" wrote in message
...
Hi Experts:

My formula is below..however, I need to add one more piece to make it work
the way I want it to...I want it to:

Look at the Dummy Report for the Dummy Location in D2:D3273 and the Dummy
Code in A2:A3273 and then return the # of records (from each code in A) in
E2:E3273 if it's greater than 3

The piece I'm missing is "Dummy Code" which I can't figure out how to add
it
to the formula.

=SUMPRODUCT(--(DUMMY REPORT'!$D$2:$D$3273="DUMMY LOCATION"),--('DUMMY
REPORT'!$E$2:$E$3273)3)

Any help you can provide would be greatly appreciated.
--
jeannie v