I've been trying to use sumproduct to get a sum of the total items in house or total items at outside vend.
I need something that will be able to differentiate from parts in house to parts outside vend and put the total sums into M2 and M4
thanks in advance for the help.
Please see the attached sample
Try this...
=SUMPRODUCT(($A$2:$A$5=1)*($C$1:$N$1="Qty")*($C$2:$N$5)) (in house)
=SUMPRODUCT(($B$2:$B$5=1)*($C$1:$N$1="Qty")*($C$2:$N$5)) (Vendor)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much, it worked perfectly.
Could you explain the formula for me, I'm a little bit lost on the way it works.
Thanks
Sure...
=SUMPRODUCT(($A$2:$A$5=1)*($C$1:$N$1="Qty")*($C$2:$N$5)) (in house)
the 1st part ($A$2:$A$5=1) tests to see if A contains 1
For those rows that have 1 in column A, it then checks to see if the heading is "QTY" ($C$1:$N$1="Qty")...this part is to make sure you dont start adding in numeric part numbers..., then adds the relevant values inthe range ($C$2:$N$5)
Hope that helps?
Thank you , you have been very helpful.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks