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