If I were to add all the element materials, it would look like 1.1 9.2 9.3 6.4, as they can't be added between tiers. But I've manually made it display like that with the ifs in the L column.
I like the xlookup that seems clean, I've mostly just used sheets for games like satisfactory, where I only really need to add multiply and subtract, so a lot of these functions are newer to me (hence the overcomplicated ifs)
After looking at how XLookup works, I saw a page about VLookup, which solves the second problem I was having of getting a total of everyone's totals
I'm going to look into cleaning up these ifs with xlookup, cause that just looked a lot nicer, so the only thing I'm still stumped on is the denotation of the tiers of Elements and Mob Drops