Sumproduct #value

[guillaume]

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

 

[David Biddulph]

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

 

[guillaume]

I learned something today It worked perfectly! Thank you