How do i make this formula not case sensitive?

That's brilliant, i can use that.

Was a bit trickier to implement due to alot of other formulas getting messed up because of the " Find/Replace all: |=SUM and replace with: =SUMPRODUCT"

But its working now, thanks alot!