LinkBack URL
About LinkBacks
Before we go to the 'twist', does this formula in H5, copied down take care part of the need?
=SUM($M5:$S5)+SUMPRODUCT(($M5:$S5=$B$5:$B$23)*$C$5:$C$23)
Before we go to the 'twist', does this formula in H5, copied down take care part of the need?
=SUM($M5:$S5)+SUMPRODUCT(($M5:$S5=$B$5:$B$23)*$C$5:$C$23)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes, apart from it only needs to sum D values, not numbers!
It also needs to reference the whole table, incase duties are added, and do that vertically as well!
Does this, in H5, copied down take care of that?
=SUMPRODUCT(($M5:$S5=$B$5:$B$23)*$C$5:$C$23)+SUMPRODUCT(($M5:$S5="D"&MID($B$5:$B$23,2,3)+100)*$D$5:$D$23)+SUMPRODUCT(($M5:$S5="D"&MID($B$5:$B$23,2,3)+200)*$E$5:$E$23)
Perfect! Just need to sum the columns and its good to go!
I would have aproacehd the whole spreadsheet differently, but the company is set in its ways, so I had to make it as similar to the origninal as possible!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks