Hi! I've got a column of products. Beside it, I've got a column of the prices. Then, each customer has a column, and the quantity of each product ordered is listed in the row of the product. Is there a quick way have excel multiply each product X price, then added together for a total? Without having to manually insert the formula for each thing...
File attached. Pardon my profound excel-ignorance, and thank you for your help!
Bookmarks