I'm guessing since there is no sample but maybe =SUMPRODUCT(($A:$A=$E2)*($B:$B=F$1)*($C:$C)) dragged down and right.
AND, by the way, I'd adjust the ranges instead of using whole columns.
I'm guessing since there is no sample but maybe =SUMPRODUCT(($A:$A=$E2)*($B:$B=F$1)*($C:$C)) dragged down and right.
AND, by the way, I'd adjust the ranges instead of using whole columns.
Last edited by Sam Capricci; 10-29-2018 at 05:48 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks