Sum if and Vlookup
Hello there,
I need to add all quantities of a column which have similar characteristics mentioned in another column. It must be very easy but I couldn't do it.
I am going to use a VLOOKUP command to find all the items of similar type, then add them. Something which I thought can be done by a SUMIF(VLOOKUP.... formula. But ..!
Can any one help?
Answers
-
Can you provide a screenshot with sensitive/confidential data removed, blocked, and/or replaced with "dummy data" as needed? I believe you should only need a SUMIFS based on your description, but I want to make sure I understand correctly what it is you want to do.
-
Thank you Paul,
I have attached the image. As you see I want to add all section 1 quantities in above section.
I need to look at a table which may be another sheet, and calculate the total quantity of a specific item, so I will need VLOOKUP as well.
-
You should be able to use
=SUMIFS([Column4]:[Column4], [Primary Column]:[Primary Column], "Section 1")
Just because the data is on another sheet doesn't necessarily mean you need to use a VLOOKUP. You can create cross sheet references inside of most functions including SUMIFS.
-
Thank you Paul,
the reason that I wanted to VLOOKUP, is that I intended to copy the formula for the other rows and get the reference row (e.g. Section 1) from the same row, without changing the formula content.
By the way, when I copy the formula you have provided to the next row (Section 2), the result of section 1 is also get damaged.
I apologize for this questions if they look silly. I am an amateur. 😀
-
=SUMIFS([Column4]:[Column4], [Primary Column]:[Primary Column], [Primary Column]@row)
That should be all you need.
I am not sure what you mean by "damaged"?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!