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
Check out the Formula Handbook template!