In this video, author Jess Stratton shows how to use the INDIRECT and CONCATENATE formulas in Google Sheets to dynamically update a total based on a particular sheet.
- [Instructor] Let's work with Sheets for a moment.…I have here Sheet1.…This sheet contains pledge amounts.…In cell F1 on the sheet, I have a total.…The total was created by using the Sum function…of every value that's in Column C.…Down on the bottom left-hand side, it's labeled Sheet1.…I also have another sheet, Sheet2.…I can click on that sheet,…and you'll see that it's also very simple.…This sheet contains the actual donations received…from the pledges.…
Like the pledges, Cell F1 also contains…a total amount of donations,…which is also just the sum of every number…that's in Column C.…I formatted them as currency…and I did that by clicking Format,…hovering my mouse over Number, and choosing Currency.…I can create a new sheet at any time…by clicking the plus icon…in the bottom left-hand side of the screen.…It's going to add a new sheet,…and I can rename it by either clicking the down arrow…next to the sheet or right clicking.…
I'll choose Rename.…I'll call this one Totals.…I can also move this over,…by clicking and dragging with my mouse…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons