Help with SUM formula

[SNyansa]

Hi there,

Can anyone advise if there is a formula I could use here in cell C2. I'm looking for a formula to sum the values in column but only if they have been 'ticked' here in column B. So for example I would need Option 1 to return 1000, and Option 3 would be 3000.

Any help would be greatly welcomed.

Thank You

 

[Peter_SSs]

Welcome to the MrExcel board!

Try

=SUMIFS(A6:A36,INDEX(B6:O36,0,MATCH(B2,B5:O5,0)),"><")

 

[jasonb75]

This should do it, assuming that you have used the wingdings font for the tick.

=SUMIFS($A$6:$A$36,INDEX($B$6:$O$36,,MATCH(B2,$B$5:$O$5,0)),"ü")

 

[SNyansa]

Thank You both so much!