I need a formula for column G in attached sheet to calculate the qty of each part # bought by each customer. Any help would be appreciated.
I need a formula for column G in attached sheet to calculate the qty of each part # bought by each customer. Any help would be appreciated.
In G2n copied down:
=SUMIFS($C$2:$C$20,$A$2:$A$20,E2,$B$2:$B$20,F2)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In G2 then copy down
=SUMIFS($C$2:$C$20,$A$2:$A$20,$E2,$B$2:$B$20,$F2)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Even if you choose not to do this, it's still expected that you will show common courtesy and thank your helpers in your thread. We are not minions: we are kind-hearted volunteers giving of our free time to help you. Remember this, please. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks