1) In H4 you have this formula.
=SUMPRODUCT(($B$85:$B$95=G$83)*($E$85:$E$95=H$82&"")*($C$85:$C$95))
But G83 & H85 are empties....
2) SUMPRODUCT, does not like to calulate in a column MIXED nambers and text... So in column C, you must heve only numbers. Not words like "Names" or "Salesman" or ANYTHING. So delete these..
Bookmarks