Question: how do you calculate the total revenue in excel?
Answer: Type the inventory name or ID in cell A1. ... 
Enter the sale price of the item in cell B1. ... 
Type the volume of sales in cell C1. ... 
Enter "=B1*C1" in cell D1 to calculate the total revenue for that item.
Repeat the process for each item sold, using a different row. ... 
Enter "=SUM(D1:D#)" in the next empty cell in column D.