Add to this formula to make it work
Paul:
Thank you so much! I had tried that and I must have done something wrong,
because your solution worked perfectly. I appreciate your assistance!!!!!
--
jeannie v
"PCLIVE" wrote:
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
|