Percentages, sheets

[fenway12]

Hello,

I have two questions.

1. I am tracking daily and monthly sales on a spreadsheet. I have one sheet per month. I have 6 Kiosks I am tracking. I want to compare my sales from month to month, day to day, etc. How can I add or subtract a certain percentage from my daily sales. I tried some formulas and got a circular reference warning. I would like to highlight all values for the month and add a certain percentage to all numbers. Is this possible?

2. Can I total numbers from all the sheets?

 

[asking]

Hi fenway12,

Answer to first question ~

Lets say you wished to add 8.5% to all values, 8.5% is 0.085 so to get the additional 8.5% you would multiply your values by 1.085

This can be done using paste special. Put 1.085 in a spare cell and copy it, highlight all values you wish to add the 8.5% to, go to paste special, click values, click multiply, click OK.


2nd question if all the totals in each sheet are in the same cell address e.g... G6 you would type ~
=SUM(Sheet1:Sheet6!G6)

If you only want the totals in the other sheets not including the total on the sheet you are on it would be ~

=SUM(Sheet2:Sheet6!G6)

If your totals are in different cells on each sheet I suggest you have a cell with the same location on each sheet that references the total cell.

So if your total is in H6 on sheet2, you would in a cell say J1 reference the total cell

In J1(on sheeet2) ~ =H6 Do this for each sheet and then your formula to total all cells would be ~

=SUM(Sheet2:Sheet6!J1)

Cheers

 

[T. Valko]

Hello,

I have two questions.

1. I am tracking daily and monthly sales on a spreadsheet. I have one sheet per month. I have 6 Kiosks I am tracking. I want to compare my sales from month to month, day to day, etc. How can I add or subtract a certain percentage from my daily sales. I tried some formulas and got a circular reference warning. I would like to highlight all values for the month and add a certain percentage to all numbers. Is this possible?

Maybe this...

http://contextures.com/xlDataEntry04.html

2. Can I total numbers from all the sheets?

This will sum the range A1:A10 on Sheet1 thru Sheet10:

=SUM(Sheet1:Sheet10!A1:A10)