Adding Values to Specific Cells

[Dappers excel]

Hi,

I want to add a value to each cell then have excel add each value up for me. It is for my business so quantity of products changes on the daily

Ex. Fresh F & F Box is valued at $48 - Skimmed Milk $1,60 etc.... then below will be the quantity each customer wants.

So i want at the end it to give me a total quantity and then the total cost.

HELP PLEASE, ive been trying different things for hours...

Trying to attach my excel file but wont let me.

[Pepe Le Mokko]

Trying to attach my excel file but wont let me.

Hi
have you checked the yellow banner for the how-to?

[Sam Capricci]

to attach file, have you followed the instructions at the top of the post in the yellow banner? The paperclip option does not work.

[Sam Capricci]

you were successful in attaching a workbook but there are no values in it and no manually calculated results.
Please enter some existing data and some expected results - even if they are hand calculated, help us to help you.

[Sam Capricci]

since I haven't heard anything about you updating your workbook, I'll give you a quick process to use if you want to add a value to all the cells in a column or row...
Put your value you want to add to all the cells in a cell somewhere, let's say E2 and you want to add 1.10 to all the cells in column B.
Copy E2, then highlighting all the cells in col B you want to add 1.10 to, right click >> paste special >> click Add and ok and it will add 1.10 to all the values in the area you highlighted.
You can do the same with Multiply to increase all the values in an area by 10% for example.
maybe that is what you want?