Help with formula
dteter
✭
I have 3 sheets.
- Summary Sheet
- Sheet 1
- Sheet 2
I want to take a cell on sheet 1 * cell on sheet 2 and return it to a cell on the summary sheet.
I have done it in the past but something seems to have changed and now I can't figure it out. Should be simple!
Comments
-
There might be an easier way, but you can use a different function, like SUM to reference another sheet:
=SUM({Sheet 1 Range 1}, {Sheet 2 Range 1})
then use those references in your equation:
={Sheet 1 Range 1} * {Sheet 2 Range 1}
-
Thanks for the reply! I will give that a try.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives