Hi
does
=SUMPRODUCT(--(Orders!$D$8:$D$100=83201020),--(Orders!$K$8:$K$100=""),O
rders!$G$8:$G$100)
work?
If no what is your exact problem with the existing formula?

--
Regards
Frank Kabel
Frankfurt, Germany


Thanks

This did work on the current list in the worksheet. I adapted the
formula to

=SUMPRODUCT(--(Orders!$D$8:$D$100="83201220"),--(Orders!$K$8:$K$100="")
,Orders!$G$8:$G$100).........this
works
fine as the product 83201220 was already in the list on the Orders
sheet.

When I added product 83201020 to the list on the Orders sheet and
used
the formula

=SUMPRODUCT(--(Orders!$D$8:$D$100="83201020"),--(Orders!$K$8:$K$100="")
,Orders!$G$8:$G$100).....this
failed to work.

Have you any idea why this might be.

Thanks

VC


---
Message posted from http://www.ExcelForum.com/