Dear Professionals
I have two sheets. Sheet 1 has goods codes of companies. I want to sum all a specific goods code of a company then put it in another sheet.
For example: D5 of sheet 2 will get the sum of c17 to c20 of sheet 1, E4 of sheet 2 will get the sum of c11 to c13 of sheet 1.
I tried many functions but i did not get the right result.
Please take a look at it and help me solve this.
Thank you and regards.
Welcome to the forum!
In B4 copied across and down:
=SUMIFS('Sheet 1'!$C$2:$C$30,'Sheet 1'!$A$2:$A$30,'Sheet 2'!$A4,'Sheet 1'!$B$2:$B$30,'Sheet 2'!B$3)
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.
Hi cuchi and welcome to the forum,
This problem was made for Pivot Tables. See the attached where I've done a Pivot Table on sheet 2 of your data. Time to learn about Pivot Tables? No formulas needed...
PT Names Codes ExcelEX.xls
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
it works! You are awesome, Mrs AliGW. Thank you so much, thank you.
Thank you so much, another solution by using Pivot Table. Thank you Marvin P. Thank you.Originally Posted by MarvinP
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks