Jess can only fit 26 dogs in her boutique dogsitting home-business on Edgeware Road. Any more than that is simply unreasonable. After all it’s a sharehouse, and fucking Edmund is allergic and BLA BLA BLA, the summary here is that 26 dogs is IT.
Jess is counting her store of dogs and wants to make sure that the new shipment of miniature schnauzers won’t push her numbers of beagles, Labradors and rare Algerian beaverhounds into unreasonable territory.
First, Jess starts an Excel document and enters dog breeds and numbers:
But Jess doesn’t want to count that shit manually! Jess’ll be all “14 plus 3 equals 17 plus 4 equals THERE’S A REASON I DON’T HAVE A REAL JOB CARO AND THIS IS IT”.
Here’s where Excel comes in.
Jess clicks on Autosum up the top, and then ‘Sum’ from the dropdown menu.
Then something like this will come up:
And this is fine. This is not as intimidating as the electric blue makes you feel. All it means is that where the B4:B8 is in that bracket, you can manually change those cell references and make them read just, like, B4:B5, the top two rows of data, aka Schnauzer numbers and Labrador numbers. After all, you might be downsizing Doggie Style Daycare just to specialised Schnauzer and Labrador care. And no one will blame you. If anything, they’ll be like “shoulda done that to start with. Nothing beats a Schnauze.”
(Helpful hint: DON’T RANDOMLY CLICK ANYWHERE ELSE ON THE DOCUMENT WHILE DOING THIS DELICATE SURGICAL WORK. IT WILL NOT BE PRETTY. YOU’LL BE LIKE ‘UH WHERE DID X73 PLAY INTO THIS?’)
So anyways now you have this cool thing:
And then you’re left with some awesome selective data and you can add up FUCKING ANYTHING in WHATEVER PERMUTATION YOU WANT:
OH SHIT THAT’S 27 DOGS AND WE ONLY FIT 26! TIME TO KILL A BEAVERHOUND!!
Just remember this catchy quote:
When I need to make a sum, and counting freestyle makes me mad,
I type =SUM(A1:A100) for the cells I want to add.
Happy birthday Caro. I’m saving up percentages and alphabetical ordering til next birthday.