Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct #value
I have two formulas, this one works:
=SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*(waste_t)) This one doesn't, it gives me the #value error: =SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*($L7)) L7 is a cell with "waste_t" written in it |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct #value
Well we don't know what you have in the definition of the various names you
have used, such as factory, year, type, and waste_t, but my gues is that your problem is that you forgot to use the INDIRECT function (or whatever it is called in your language's version of Excel). I think you need to replace $L7 by INDIRECT($L7) if you want it to refer to a range of cells defined as waste_t -- David Biddulph "guillaume" wrote in message ... I have two formulas, this one works: =SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*(waste_t)) This one doesn't, it gives me the #value error: =SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*($L7)) L7 is a cell with "waste_t" written in it |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct #value
I learned something today :D It worked perfectly! Thank you
"David Biddulph" wrote: Well we don't know what you have in the definition of the various names you have used, such as factory, year, type, and waste_t, but my gues is that your problem is that you forgot to use the INDIRECT function (or whatever it is called in your language's version of Excel). I think you need to replace $L7 by INDIRECT($L7) if you want it to refer to a range of cells defined as waste_t -- David Biddulph "guillaume" wrote in message ... I have two formulas, this one works: =SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*(waste_t)) This one doesn't, it gives me the #value error: =SOMMEPROD((factory=$A$3)*(type=B$5)*(year=$H$1)*( month=$J$1)*($L7)) L7 is a cell with "waste_t" written in it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT with )-- | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
=SUMPRODUCT | Excel Worksheet Functions | |||
IF/AND used with SUMPRODUCT? | Excel Worksheet Functions |