Sum formula that references other sheets
I'm trying to Sum together information from 4 separate sheets. I can easily accomplish this by referencing each sheet/cell within the SUM() formula, and it works great. The problem that I'm running into is duplicating this formula to the remaining 364 cells that I'm trying to populate. Can I use the $ symbol somehow for absolute cell reference for another sheet? The sheets that I'm pulling info from are all identical layout to each other, but represent information across 4 different districts.
Answers

You'll be interested in the reporting updates announced at Engage this year that include the ability to do SUM and other basic functions on reports. Because reports can pull from multiple sheets, I assume this will meet your need. I think the reporting updates were coming in November or January if I recall?

I'm also interested in this, if anyone has found a way. The report does work great for this, BUT when pulling that data on a dashboard, it also shows all the numbers in a cluster over the graft. This isn't feasible for client solutions. So in this case, we would need a sheet formula that has the same SUM function as the report, because it displays where clients can read and understand the information.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!