maybe by using indirect
or have a list and refer to list such as {b2,b3,b4}

--
Don Guillett
SalesAid Software

"Karin Iversen" wrote in message
...
Hello,

I want to refer to at cell in sumproduct - it works when I use the
formular:

=SUMPRODUCT(('data'!$A$23:$A$500=$A$1)*('data'!$B$ 23:$B$500={"26852030",
"28563210"})*(data'!$D$23:$D$500))

but it soes not work if i in the formular refer to a cell (B2) with
{"26852030", "28563210"} in then the results is 0. Is it possible to refer
to
a cell


=SUMPRODUCT(('data'!$A$23:$A$500=$A$1)*('data'!$B$ 23:$B$500=B2)*(data'!$D$23
:$D$500))

Hope someone can help with this.
Karin