SUMIF of row using value at top of column

[sergiomonte]

I am making a matrix of fees and would like to have the totals calculated at the end of the row if there is an "X" in the column for the fee. Just not sure how to approach this.

For example, the first row should total $22.50, second row $20.00 and so on. 

Any help is appreciated.

[#2]

Hello @sergiomonte,

In the first row, that could be:

=SUMIF(X4:AB4,"X",$X$3:$AB$3)

[#3 · Accepted solution]

@sergiomonte 

In AC4:

=SUMIF(X4:AB4,"X",X$3:AB$3)

Fill down.

[#4]

Thank you!