Hello,
I would like to use a sumproduct function to calculate a costprice. I have per type of product a price (EUR) and a qty (QTY). For the type GUZ, I have GUZEUR and GUZQTY, for TIL, I have TILEUR and TILQTY, etc.
Problem is that all my desciptions are in column A (GUZEUR, GUZQTY, TILEUR, TILQTY, etc) and all my amounts are in column B.
How can I use the sumproduct formula?
See example attached.
Thanks.
I dont see the need for a sumproduct at this point, it seems you just need to create the three formulas once then you are finished.
Formula in B8 then drag down to B10:Am I missing something?
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Sumproduct.xlsx
And what if you have more than 1 GUZ type? See attached.
see the attached file
this in an array formula with sumproduct and mmult functions
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks