I am doing a material takeoff from mechanical drawings (70 in total) and need to count the number of time a product code appears in a column. Then x it by the number of units needed in column next to the code. This will then give me the total number of products needed for the whole job. I was looking at VLOKUP and COUNTIF but kept getting errors. Any suggestions.