Sum if and Vlookup

Mehran Bagherian

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?

Paul Newcome

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.

Mehran Bagherian

sumif-lookup.jpg

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.

Paul Newcome

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.

Mehran Bagherian

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. 😀

Paul Newcome

=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"?