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