Subtotal if values in another column are unique

[SK1982]

Hello! I need to subtotal a column when it's filtered. But since there are duplicates in my report, I need to only subtotal values in my column when the value in another column is unique.

Right now the formula I have to subtotal is =SUBTOTAL(9,AX6:AX38955). How do I make it so that it sums the value in AX only where the value in column AG is unique?

I so appreciate the help!

 

[gargamalebarbosa]

Hi, if you accept solution with "helper column" i can share formula.