Excel Question

Factual Questions
1

So I am working on a budget spreadsheet, and I am trying to get a total on one worksheet to another. What coding would I use to have a total from cell K6 on the worksheet “paydays” to show up in cell C20 on “Bills to pay this paycheck”? Note I am a novice at excel, I can do a little bit of stuff on a single worksheet but not anything from sheet to sheet.

2

You can reference other worksheets in this form:

=SUM(paydays!A1:A3)

You just need the = followed by the name of the worksheet (paydays) followed by ! then the cell or range of cells.

Any formula can be built with that convention as well.

= then the name of the worksheet then ! then the cell reference. A range of cells is separated by a :

3

Thanks Shagnasty - you rock - it worked perfect!