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.

 

[Marcelo Branco]

Try

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

or
=SUMPRODUCT($V$6:$V$60+$Z$6:$Z$60,--($B$6:$B$60="Carp"))/V69

M.

 

[zone709]

Thank you for this I am actually using the =SUMPRODUCT and it works fine. I am trying to do one more thing. I been trying it with the sumifs but rather the sumproduct.


=(SUMIFS($V$6:$V$60,$B$6:$B$60,"Carp")+SUMIFS($Z$6:$Z$60,$B$6:$B$60,"Carp")/SUMIFS($T$6:$T$60,$B$6:$B$60,"Carp")) trying to divide this last part / Divide values from column T if carp in B

 

[Marcelo Branco]

I'm not understanding what you are trying to do with this new formula. Isn't it working?

M.

 

[zone709]

​Sorry yes its returning a number and not a error, but the number is different and trying to figure out why at this time

 

[Marcelo Branco]

Still not clear. The number is different from what?

M.

 

[Marcelo Branco]

I think i'm understanding your problem now. The last parenthesis seems to me wrong.

Maybe
=(SUMIFS($V$6:$V$60,$B$6:$B$60,"Carp")+SUMIFS($Z$6:$Z$60,$B$6:$B$60,"Carp"))/SUMIFS($T$6:$T$60,$B$6:$B$60,"Carp")

M.

 

[zone709]

This is what I am using now on this last part I'm trying to figure out. =IFERROR((V6:V14+Z6:Z14)/(T6:T14),0) returns 102.08 as I am adding both V and Z in that range Dividing it with the T range.

When I use =(SUMIFS($V$6:$V$60,$B$6:$B$60,"Carp")+SUMIFS($Z$6:$Z$60,$B$6:$B$60,"Carp")/SUMIFS($T$6:$T$60,$B$6:$B$60,"Carp"))

When I use this one above. I return $9554.67. I feel like this part needs to be change somewhat SUMIFS($T$6:$T$60,$B$6:$B$60,"Carp")) . Trying to figure our why its returning this high number if its taking the same range

 

[zone709]

Yes that was it thank youuuuuu ) I new I was missing something small thanks

 

[Marcelo Branco]

You are welcome. Glad to help.

M.