# Excel Question

**URL:** <https://boards.straightdope.com/t/excel-question/353421>\
**Category:** Factual Questions\
**Created:** [April 20, 2006, 3:18am UTC](https://boards.straightdope.com/t/excel-question/353421 "2006-04-20T03:18:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rwhbyu](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@rwhbyu](https://boards.straightdope.com/u/rwhbyu)\
**Post date:** [April 20, 2006, 3:18am UTC](https://boards.straightdope.com/t/excel-question/353421/1 "2006-04-20T03:18:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Shagnasty](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Shagnasty](https://boards.straightdope.com/u/Shagnasty)\
**Post date:** [April 20, 2006, 3:28am UTC](https://boards.straightdope.com/t/excel-question/353421/2 "2006-04-20T03:28:44Z")

</div>

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 :

---

<div class="post-metadata">

**Author:** ![rwhbyu](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@rwhbyu](https://boards.straightdope.com/u/rwhbyu)\
**Post date:** [April 20, 2006, 4:00am UTC](https://boards.straightdope.com/t/excel-question/353421/3 "2006-04-20T04:00:39Z")

</div>

Thanks **Shagnasty** - you rock - it worked perfect!