| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace SUMIF with SUMPRODUCT
I am trying to replace the formula listed below with SUMPRODUCT:
=SUMIF('M:\M Inc\F2007\Revenue, Volume and Expenses By Client \Calculation Templates\[TD F2007 January Revenue and Volume Statistics.xls]Sheet1'!$E$164:$E$171,$A8,'M:\M Inc\F2007\Revenue, Volume and Expenses By Client\Calculation Templates\[TD F2007 January Revenue and Volume Statistics.xls]Sheet1'!$F$164:$F$171)+SUMIF('M:\M Inc\F2007\Revenue, Volume and Expenses By Client\Calculation Templates\ [TD F2007 January Revenue and Volume Statistics.xls]Sheet1'!$E$130:$E $156,$A8,'M:\M Inc\F2007\Revenue, Volume and Expenses By Client \Calculation Templates\[TD F2007 January Revenue and Volume Statistics.xls]Sheet1'!$F$130:$F$156) Replacing the sumif with =SUMPRODUCT(- gives me th #value error. Thanks in advance for your assitance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace SUMIF with SUMPRODUCT | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| Help for sumif / sumproduct | Excel Worksheet Functions | |||
| sumif vs sumproduct | Excel Worksheet Functions | |||
| SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions | |||
Threaded Mode
