Question for owners/those who work in escape rooms:
A friend owns an escape room business. There's a franchise about to open within a 15 minute walk of him in a touristy city. How concerned should he be? He's losing his 💩 right now
In February/March 2026, I started getting a notice that my battery health was low and I should go to the dealership and replace it. After doing a bunch of research here and YT, I decided to save myself some coin and replace it myself. Bought a 12v from Rock Auto and changed it. Reset the BMS.
After coming home from a trip, gone 5 days, my console lit up like Christmas with that stop safely now like message before I could start it. Popped open my frunk.
Planning to check/recharge my 12v tomorrow. Should I reset BMS after charging it? Should I disconnect the terminal before charging and then reset it? How do I know if I got a lemon battery?
So I have several sheets of data.
Sheet1:
Identifier
Sheet2:
Find the identifier within the row. I have hundreds of rows of data. If an identifier is in the first 3 values, I want to add the first column after the break, 10. If the identifier is in the second set of 3 values, I want to add the column after that, 100.
I want to add a column Sheet1 to contain the sum of that given identifier for my all my data rows. The data in the 6 columns will never have duplicates.
It would be something like this if I wanted to add a single row, but I want it to add all of my data rows.
=IF(COUNTIF(Sheet1!B1:D1, A2) > 0, Sheet1!L1, 0) + IF(COUNTIF(Sheet1!E1:G1, A2) > 0, Sheet1!M1, 0)
How do I find a single sum for a given identifier for multiple rows of data where I want to get the sum of a column if that identifier is in a different column?
