u/Confused_Crossroad

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

https://preview.redd.it/7p7vv2lg4gyg1.png?width=128&format=png&auto=webp&s=7bce4e6ca02e9cb9ea5e3080ade52017af0a179d

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.

https://preview.redd.it/vjdopflt4gyg1.png?width=1336&format=png&auto=webp&s=abf8ad27472f93a56dcd8864f42dcbea7cb6aa7a

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?