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

 

[zone709]

I'm back sorry ran into one more thing. I Need to do this

=SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")+

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

Basically I need to add both sums right and divide it into the 2 added numbers

BV77+BZ77 to get my %​

these are my real number [TABLE="width: 213"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD="align: right"]8782[/TD]
[TD="align: right"]/ 25296[/TD]
[TD="align: right"]34.717%
[/TD]
[/TR]
</tbody>[/TABLE]

For some reason I can get 34.717%
I get a wacky number like 6.800000454

Just wanted to see if you knew why thanks
​

 

[jtakw]

Without seeing your data, just by looking at the formula you're now using, you're missing brackets at the end:

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

 

[zone709]

HI I am back and sorry about this. Just trying to get to the bottom of it.
If I don't use =sumifs I get the right calculation below in red

=SUM(BV24:BV35,BZ24:BZ35)/(BV77+BZ77) comes out to 34.717% ------- right

If I use the sumifs I get almost double the calculation. I feel that something minor need to be changed below to get the right number 34.717 I just cant figure it out why its doubling value.

=SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")+SUMIFS($BZ$6:$BZ$72,$B$6:$B$72,"Operator")/(BV77+BZ77) comes out to 641859.57% --------Wrong

 

[zone709]

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

I got it to work

 

[jtakw]

I'm back sorry ran into one more thing. I Need to do this

=SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Operator")+

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

Basically I need to add both sums right and divide it into the 2 added numbers

BV77+BZ77 to get my %​

these are my real number [TABLE="width: 213"]
<tbody>[TR]
[TD="align: right"]8782
[/TD]
[TD="align: right"]/ 25296
[/TD]
[TD="align: right"]34.717%
[/TD]
[/TR]
</tbody>[/TABLE]

For some reason I can get 34.717%
I get a wacky number like 6.800000454

Just wanted to see if you knew why thanks
​

Without seeing your data, just by looking at the formula you're now using, you're missing brackets at the end:

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

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

I got it to work

Ah yes, I missed that you were missing the brackets in the first part as well in my post #12 .
Happy you fixed it and got it working.