Sum if and Vlookup
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?
Help Article Resources
Check out the Formula Handbook template!