Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make the division work in my formula | Excel Worksheet Functions | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
Urgent - make formula work with both decimal separators | Excel Discussion (Misc queries) | |||
one formula to make a multiplication table work | Excel Worksheet Functions | |||
How do I make this formula work =if(a1=(b10:b20),"good","bad"). | Excel Worksheet Functions |