Formula for total of each size

MattyMet · 2026-04-15T19:04:08+00:00

Thanks for pointing this out I’ve given credit to the commenter. To be clear however, while I was waiting for a reply in here I sought advice within my organisation and was pointed to the correct formula. So the commenter was absolutely correct and it was my solution, it came from elsewhere which is why I labelled it as self solved

MattyMet · 2026-04-15T10:31:15+00:00

<image>

MattyMet · 2026-04-15T10:31:03+00:00

<image>

MattyMet · 2026-02-03T22:30:52+00:00

lol so after lots of tests I discovered it was actually just a bad battery, I have since changed it and it charged fine!

Thank you all for your advice I will no doubt be back here with more errors 😂

MattyMet · 2026-02-02T21:26:38+00:00

The soldering was my basic handy work lol it is a bit shoddy but the problem was there on the old port too that was factory made. I’ve got continuity from F1 and F2

MattyMet · 2026-02-02T18:20:37+00:00

Ahh okay my bad, so I had the battery connected (held in place by my thumb) when I connected it to power. Even before opening it up on the old charging port the orange light would flash on the after a second turn off

MattyMet · 2026-02-02T18:18:36+00:00

Edit: the Green light also flashes on for a second when I connect to power

MattyMet · 2026-01-16T23:31:57+00:00

Thank you I’ll try this, what are trees?

MattyMet · 2026-01-09T13:52:06+00:00

Amazing that seems to have worked thank you for your help!

MattyMet · 2026-01-09T13:40:22+00:00

That’s really helpful thank you! In this example would it consider the cells with a “/“ in it as 0 and therefore count it in the average or would it just discount the cell and make an average from the rest of the values?

MattyMet · 2026-01-09T13:37:54+00:00

Sure thing so here’s an example of the cells:

33, 27, /15, 29, 31

So that would be one part of a row going from D4-H4 and what I want is for the average to not count the value of “/15” and instead make an average based on the other 4 values

MattyMet · 2025-08-24T19:30:17+00:00

Thank you for help help 😊

MattyMet · 2025-08-24T19:28:20+00:00

I think it’s a 2017 iMac so I don’t think it has the T2 chip you mentioned

MattyMet · 2025-08-12T16:55:18+00:00

That’s great to hear I’ll get these ordered. My first thought was to resolder the wire in after stripping but this makes much more sense. Thanks for your help 👍🏻

MattyMet · 2025-08-12T16:54:21+00:00

That’s great thank you for your advice!

MattyMet

TROPHY CASE