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 sizes or quanities by the price of that item with a total of all the items.
| Champions Black Sweatshirt $52 | Bella Canvas Black Sweatshirt $30 | Champions White Sweatshirt $52 | Bella Canvas White Sweatshirt $30 | Water Jub $35 | TOTAL DUE |
| $52.00 | $30.00 | $52.00 | $30.00 | $35.00 | |
| MED | 0 | 0 | 1 | $ 52.00 |
2 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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.
