Sumif formula Simplification

Hi Guys
I have created a spreadsheet with a bunch of sumif formulas. I couldnt get them to work properly and then did this formula =SUMIF($D$2:$D$39,"*R10*",$B$2:$B$39)+SUMIF($E$2:$E$39,"*R10*",$B$2:$B$39)+SUMIF($F$2:$F$39,"*R10*",$B$2:$B$39)+SUMIF($G$2:$G$39,"*R10*",$B$2:$B$39)+SUMIF($C$2:$C$39,"*R10*",$B$2:$B$39). Now this formula works fine but I know there must be a simpler solution. I have tried sumproduct and sumifs but they didn't work properly. It would be greatly appreciated if someone is able to help me simplify my formula. I find this happens to me a bit sometimes and I just cannot figure out the best way of simplifying them.
Thanks In advance
Tristan

Hi,

Can you please upload your workbook?

Thanks

TOTAL QUANTITES TEST.xlsx Here is the file as requested my apologies

Originally Posted by Tristanfrontline

Here is the file as requested my apologies

Try:

=SUMIF($D$2:$G$39,"*R10*",$B$2:$B$39)

Sorry, but I can't find an easier formula for you either

That's ok thanks for trying though. As I said my way works but it just looks like there would be a simpler way and I am sure there probably is. I just can't figure it out

Thanks Chinraj that kind of works except its missing the data from column "c" (under Robes A) is there a reason why it would see the info in the other columns but not column "c"?