Formula ?

[zone709]

=SUMIFS($V$6:$V$60,$Z$6:$Z$60,$B$6:$B$60,"Carp")/V69

What I am trying to do is Add V + Z values taken if Carp is in Column B then dividing it with /V69

Almost got it but missing something.

 

[zone709]

Hi I came back to this post as I been using the formula we went over awhile back. Its working fine but I need to add something on it.

=(SUMIFS($BX$6:$BX$72,$B$6:$B$72,"Carpenter")+SUMIFS($CB$6:$CB$72,$B$6:$B$72,"Carpenter"))/SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Carpenter")

I need it to divide the total now of both which the first line I already have but need the second also in red

SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Carpenter") & this ​

SUMIFS($BZ$6:$BZ$72,$B$6:$B$72,"Carpenter")


​

I tried something like this but know go.

=(SUMIFS($BX$6:$BX$72,$B$6:$B$72,"Carpenter")+SUMIFS($CB$6:$CB$72,$B$6:$B$72,"Carpenter"))/SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Carpenter")+

SUMIFS($BZ$6:$BZ$72,$B$6:$B$72,"Carpenter")​

​

​

​

_{^{<strike>
</strike>}}​

 

[Marcelo Branco]

This?

=(SUMIFS($BX$6:$BX$72,$B$6:$B$72,"Carpenter")+SUMIFS($CB$6:$CB$72,$B$6:$B$72,"Carpenter"))/(SUMIFS($BV$6:$BV$72,$B$6:$B$72,"Carpenter")+SUMIFS($BZ$6:$BZ$72,$B$6:$B$72,"Carpenter"))

M.

 

[zone709]

​yep thank you so much that was it ( )