SOLVED

SUMIF of row using value at top of column

%3CLINGO-SUB%20id%3D%22lingo-sub-1680877%22%20slang%3D%22en-US%22%3ESUMIF%20of%20row%20using%20value%20at%20top%20of%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1680877%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20making%20a%20matrix%20of%20fees%20and%20would%20like%20to%20have%20the%20totals%20calculated%20at%20the%20end%20of%20the%20row%20if%20there%20is%20an%20%22X%22%20in%20the%20column%20for%20the%20fee.%20Just%20not%20sure%20how%20to%20approach%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20the%20first%20row%20should%20total%20%2422.50%2C%20second%20row%20%2420.00%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22fees.JPG%22%20style%3D%22width%3A%20425px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219344i8433EEEA9F59A7A6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22fees.JPG%22%20alt%3D%22fees.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1680877%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1680930%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20of%20row%20using%20value%20at%20top%20of%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1680930%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F797933%22%20target%3D%22_blank%22%3E%40sergiomonte%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20first%20row%2C%20that%20could%20be%3A%3C%2FP%3E%3CPRE%3E%3DSUMIF(X4%3AAB4%2C%22X%22%2C%24X%243%3A%24AB%243)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

fees.JPG

 

 

 

3 Replies

Hello @sergiomonte,

 

In the first row, that could be:

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

 

Best Response confirmed by sergiomonte (New Contributor)
Solution

@sergiomonte 

In AC4:

 

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

 

Fill down.

Thank you!