| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
aaronwelxer,
Along Bob's line, and as SUMPRODUCT allows only arrays of the same sizes, the following formula ought to work: =SUMPRODUCT(--(Sheet1!D2:D655360),--(Sheet1!B2:B65536=1)) + SUMPRODUCT(--(Sheet1!E2:E655360),--(Sheet1!B2:B65536=1)) + SUMPRODUCT(--(Sheet1!F2:F655360),--(Sheet1!B2:B65536=1)) Of course this formula leaves a lot to be desired because when your range grows and includes more columns, the formula needs to be modified correspondingly. In the meantime, hope this will serve the purpose. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| countif variable criteria | Excel Discussion (Misc queries) | |||
| Formula Does Not Omit Criteria | Excel Worksheet Functions | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Threaded Mode
