# =SUM(Price*Quantity) and microsoft help is no help at all

1. ## =SUM(Price*Quantity) and microsoft help is no help at all

Hi

I'm not sure how to do this, but I want the Total (column D) to be the sum of the Unit Price (column C) times the Quantity (column A). Is there a formula you can apply to a column or do I have to do it in individaul cells?

2. Why isn't your formula in column D simply

=C1*A1

And then copy it down the column?
???

3. It depends what you require
on an individual line basis the previous answer copied down will work

If you wished to have the sum of the above at the bottom and your data was in a2:c10

sumproduct((a2:a10),(c2:c10))

or sum(a2:a10)*sum(c2:c10)

Depends what you want

Regards

Dav

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1