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
Highlighted
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
Highlighted

Hello @sergiomonte,

 

In the first row, that could be:

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

 

Highlighted
Best Response confirmed by sergiomonte (New Contributor)
Solution

@sergiomonte 

In AC4:

 

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

 

Fill down.

Highlighted
Thank you!