| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Morrigan, thanks for your help, that's exactly what I wanted. Appreciate it.
Smock "Morrigan" wrote: Is this what you want: =SUMPRODUCT(--(Sheet1!F2:F1900='1340 - 001'!B8),--(Sheet1!D2:D1900='1340 - 001'!C8),--(Sheet1!C2:C1900='1340 - 001'!F8),--(Sheet1!G2:G1900='1340 - 001'!G6),Sheet1!J2:J1900) -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=469906 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to .. | Excel Discussion (Misc queries) | |||
| excel | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Hybrid Mode
