How do I reference cells on a different sheet?
http://courses.robobunnyattack.com/co...
This lesson walks you through how to reference cells on another sheet in the same spreadsheet file, like this:
=SUM('Some Other Sheet'.D2:D1644)
To access downloadable files and other goodies, enroll at http://courses.robobunnyattack.com/co...
*****
This is a sample lesson from the online course "Use Spreadsheets Confidently: Navigation, Functions and More". Supercharge your spreadsheet & data management skills! Learn essential Excel functions, data clean-up tricks and more. Enroll today at: http://courses.robobunnyattack.com/co...
Looking for friendly, practical, jargon-free technology training? Visit my website at: http://learn.robobunnyattack.com
Thanks for watching!
Kathleen, [email protected]