Benjamin Wilson7 said:In that first sheet where you need to sum up those other 99 numbers:
Just hit AutoSum. It’ll pop up =SUM() for you. Easy.
Next, hit Sheet2. Hold down Shift and click on that last one, Sheet99. Done.
Why even bother with "Shift"? Like I’m suddenly gonna select everything from Sheet2 all the way to Sheet99? That kind of grouping is useless. Using CTRL just skips over the stuff you don't want—like jumping from Sheet3 to 5 to 17. Makes zero sense.
Go to cell B68 and hit enter.
4. I'll be typing it right in the formula bar. Just a quick heads-up if you're trying to pull data from a massive range of tabs—this formula `=SUM(Sheet2:Sheet99!B68)` works in Excel to grab cell B68 from every single sheet between Sheet2 and Sheet99. It’s basically a shortcut so you don't have to click through a hundred different tabs manually. Just make sure those sheets actually exist or the whole thing breaks. Simple, but handy.Basically just the sum of all those B68 values.
Either just punch the formula in manually, but honestly? You’re better off messing around with that Shift key trick instead.
There’s other ways to do it, but this one’s your best bet.
Thanks a ton. 🙂