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

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".

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.

Can you please upload your workbook (Reply --> Go Advanced --> Manage Attachments).

Thanks

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.

I recommend you do as ajryan88 says and upload a workbook, easier to help you then.

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.

Can you please upload your workbook (Reply --> Go Advanced --> Manage Attachments).

Thanks

Thank you

Hi,

Find the updated file.

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

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.

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

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

Thank you all guys I managed to make it work