[Solved] Checking similar values of multiple cells

[lizard]

Here's one I'm getting a headache over.

So I need a SUM value based on two factors.
1. The value of the cell
2. The type of value of the cell

From there the SUM needs to be equal to the value of all cells, but if a type of value is the same only add into the sum the higher of the two.

Attached file because even that statement is confusing me.

[RusselB]

While I wasn't able to get something to actually work, I have a feeling that the SUMPRODUCT function is your best bet.
While I have used the function occasionally, when it gets to the more complicated operations, which the function can handle, I usually end up screwing something up.
There are a few helpers on here that have helped me get the function to work properly for my needs, so I'm hoping one of them will have a brainstorm.

[MrProgrammer]

See my array formulas in cells B1, C1, and D1. Note that array formulas require ⇑⌘Enter on a Mac or Ctrl+Shift+Enter on other platforms. If you type an array formula but press Enter instead, correct your mistake with Edit → Undo, then try again. In addition to the link above you can read about array formulas in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum.

201808152241.ods

(11.61 KiB) Downloaded 64 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[lizard]

Well done MrProgrammer.

Thank you very much.