Forum Discussion

Copper Contributor

Dec 16, 2020

Excel Help for fairly new user

I am working on an older worksheet from a excel document some else created that has multiple pages. I have saved this as a new document for me to make changes since this is a new job from the origin...

BattleRidge-Warhorse Weekly Report.xlsx208 KB

excel

rhancock

Brass Contributor

Dec 16, 2020

sumrall90

I think it might help if you know the elements of the formula used:

=+B6+(@'Dec 14-20'!D6:E6)

translates to

"Add the cell B6 in this worksheet to cells D6 through E6 on the sheet 'Dec 14-20'"

You can change that formula manually, or you can click in the total cell, type:

click B6

type +

click the cell in the other sheet to add to.

Hope that's clear 🙂

To c

sumrall90
Copper Contributor
Dec 16, 2020
rhancock I did try typing it in manually and it would not work (put in correct information from formula). I even tried to copy and paste the formula and just change the dates. I guess what I am not understanding is why it is working on the first 5 pages and then on the 6th it does not calculate correctly. I am sure it is something that I have done! Were you able to look at the document? Thank you for your help!!