Sum multiple columns, each column based on criteria from different columns

Hi Everyone,
I am trying to sum the values of 4 columns, based on criteria from 4 other columns.

This is the latest formula I have tried. I get a return of VALUE

=SUMPRODUCT((E7:E16="X")*(F7:F16)+SUMPRODUCT(J7:J16="X")*(K7:K16)+SUMPRODUCT((P7:P16="X")*(Q7:Q16)+SUMPRODUCT(U7:U16="X")*(V7:V16))

In my example the return should be $3333.73.
From the "X" in columns E,J,P,U the numbers that correspond with them in columns F,K,Q,V.

I have tried SUMIF AND SUMIFS also.

Thank you very much for any and all help!

Maybe the problem is your several rows on your column is not really empty, try to sselect the empty cells and delete it and hope this works because the formula is fine to me