| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT Criteria Via Cell Reference??
SUMIF allows one to enter a [valid] criteria text string into cell D2, say
"14000", and then reference D2 as the function criteria, e.g., =SUMIF(B5:B10,D2,C5:C10). Is there a syntax that SUMPRODUCT will accept that does the same thing? Note the inclusion of a comparison operator is important. Thanks! JV |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
