Formula help =SUMIFS

[zone709]

This works:
=SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")/BV77

Need to addition another column also in this, but I cant getit to go in red. Any help appreciate it.
=SUMIFS($BV$6:$BV$72+$BZ$24:$BZ$65,$B$6:$B$72,"Operator")/BV77

 

[Scott T]

Is this what you are trying to do?
=(SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")/BV77)+(SUMIFS($BZ$24:$BZ$65,$B$6:$B$72,"Operator")/BV77)

 

[jtakw]

Hi,

Yes, you'll need to SUM the 2 SUMIFS..
Please also notice that your new Sum Range BZ24:BZ65 is not the same size as the Criteria Range B6:B72.

 

[zone709]

Yes close but actually it returns #value I don't know why and also forgot to mention this I need \BZ77 not BV77

(SUMIFS($BZ$24:$BZ$65,$B$6:$B$72,"Operator")/​

BZ77​

)​

 

[zone709]

that's ok on my end I don't want to sum it before BZ24

 

[jtakw]

that's ok on my end I don't want to sum it before BZ24

Then why not =SUMIFS($BZ$24:$BZ$65,$B$24:$B$65,"Operator")/BZ77

 

[zone709]

but I also need the BV:BV72 \ BV77 ? So the outcome of % it will add the % of BV77 AND BZ77

Why I was looking for something like this

=(SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")/BV77)+(SUMIFS($BZ$24:$BZ$65,$B$6:$B$72,"Operator")/BZ77) like scott mention but its returning #value​

 

[jtakw]

You're getting #VALUE error because the range size doesn't match up, try this:

=SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")/BV77+SUMIFS($BZ$24:$BZ$65,$B$24:$B$65,"Operator")/BZ77

 

[zone709]

Yep that was it thanks a lot. When I seen this I was like that's itttt thanksss

 

[jtakw]

You're welcome, glad you got it sorted out.