Forum Discussion
formula help
I have a spreadsheet where it list if a person is ordering a certain item and what size they are requesting. I need a formula that will use the total column to add together all the items that have s...
To calculate the total due based on item quantities and prices in Excel, use a formula like =(B2*$B$1)+(C2*$C$1)+(D2*$D$1)+... where row 1 has the prices and row 2 has the quantities. This multiplies each item's quantity by its price and adds them up in one step.