SUMPRODUCT Question

I’m trying to use a SUMPRODUCT formula to add multiple rows together based off a couple different criteria. When I do it for just one row I can get it to work. However, when I try to use it for multiple rows i get #VALUE error. Not sure what I need to do here.

When F22 equals Forecast and H22 equals AMS it adds cell L22 and M22 together and then multiplies that by cell G22 (percentage) and it works fine.

SUMPRODUCT(($F$22=”Forecast”)*($H$22=”AMS”)*$L$22:$M$22)*$G$22

However when i do it like below trying to multiple each row by column G before adding i get an error. Anybody know how i can get around this? Here is what i tried….

SUMPRODUCT(($F$22:$F$200=”Forecast”)*($H$22:$H$200=”AMS”)*$L$22:$M$200)*$G$22:G$200

 

Thanks

By: Kevin

Leave a Reply

Your email address will not be published. Required fields are marked *