# Calculating Sum of Column by Column

1. ## Calculating Sum of Column by Column

Hi, I have no idea about excel formulas or programming whatsoever and I need your help guys.
I am making an order for my shop and I want to multiply product price X (Column #1) with quantity Y (Column #2) and sum it. I have a picture attached to help you understand better what I want.
uznSuuc.png
I want it to be A2*B2+A3*B3+A4*B4+A5*B5+A6*B6+A7*B7=Z (Total)

BTW My office version is 2010.

2. ## Re: Calculating Sum of Column by Column

Hi,

Look at the SUMPRODUCT function:
Formula:
`Please Login or Register  to view this content.`
I hope this helps

3. ## Re: Calculating Sum of Column by Column

Originally Posted by ajryan88
Hi,

Look at the SUMPRODUCT function:
Formula:
`Please Login or Register  to view this content.`
I hope this helps
Sadly it doesn't, the output is "0".

4. ## Re: Calculating Sum of Column by Column

Well the output of =SUMPRODUCT(A2:A7,B2:B7) should be A2*B2 + A3*B3 + ... + A7*B7 as required, by the definition of the SUMPRODUCT function.

Thanks

5. ## Re: Calculating Sum of Column by Column

It might be the settings. Some has ; instead of , as separator between arrays.
But then you should have gotten an error message instead of a 0.

6. ## Re: Calculating Sum of Column by Column

Originally Posted by ajryan88
Well the output of =SUMPRODUCT(A2:A7,B2:B7) should be A2*B2 + A3*B3 + ... + A7*B7 as required, by the definition of the SUMPRODUCT function.

Thanks
Thank you

7. ## Re: Calculating Sum of Column by Column

Hi,

Find the updated file.

Punnam

8. ## Re: Calculating Sum of Column by Column

hi ,

The problem is with "\$" sign it is not necessary to insert "\$" in cell for its representation it can done by changing the format .

Punnam

9. ## Re: Calculating Sum of Column by Column

Originally Posted by Punnam
hi ,

The problem is with "\$" sign it is not necessary to insert "\$" in cell for its representation it can done by changing the format .

Punnam
Is there a way of making it work with "\$"? Can you guide me through to make it work with it?
Thank you very much it does work without the "\$", but it will be awesome if I could make it work with the "\$" symbol.

10. ## Re: Calculating Sum of Column by Column

Mark the cells, right click choose format cells, choose custom in the menu to the left.
In the type field write: "\$"0.00
Then ok.
That should work

11. ## Re: Calculating Sum of Column by Column

hi SilenceFiction

Need some clarification ,

1) i have modified the format to meet u r requirement
2) Is it mandatory for u enter the "\$" sign in a cell ? or just under viewing i mean like printing and presentation.

Punnam

12. ## Re: Calculating Sum of Column by Column

ermm, in the cell you want the '\$' is this just to show it's currency (as in you want a dollar value?)
In which case, just format as Currency

13. ## Re: Calculating Sum of Column by Column

Thank you all guys I managed to make it work

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