Add to this formula to make it work
 

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

Add to this formula to make it work
 

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

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

Add to this formula to make it work
 

You're welcome.


--

"jeannie v" wrote in message
...
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