Formula Help ?

[zone709]

What I am using now:
=SUM(T24+T25)/T64
=SUM(V24+V25+Z24+Z25)/(V$66+Z$66)
=IFERROR((V24+V25+Z24+Z25)/(T24+T25),0)

Trying to see if I can do this. In column B range B6:B60 I have the word Operator in multiple cells.
What I am trying to do for each formula is if Operator is in column B. Trying to add the sum of always column V and Z. As you can see I have T24+T25 and V24+V25+Z24+Z25 Etc.
I was thinking instead of me keep on adding more ranges like + + + when Operator is present in column B to have these numbers come from reference if Operator is in Column B. Anything after /(with always stay the same. Its more of the beginning of the formula before the division /.


What I am thinking as this doesn’t work at the moment,but this might explain on more what I am trying to do.
=SUMIFS(T6:T60,B6:B60,"Operator"/(T64)
=SUMIFS(V6:V60+Z6:Z60,B6:B60,"Operator"/( V$66+Z$66)
=IFERROR((V6:V60+Z6+Z60),”Operator”/(T24+T25),0)

Thanks

 

[zone709]

That last formula gave me error. DIV


So the results =SUM(D6:D10+F6:F10)/(D14+F14) gives me 18%


=SUM(D6+D7+D8+D9+D10+F6+F7+F8+F9+F10)/(D14+F14) this gives me 90%

I think the : is giving me the wrong higher number

 

[63falcondude]

I'm not saying that this is the answer to your question, but

=SUM(D6:D10+F6:F10)/(D14+F14)

should be

=SUM(D6:D10,F6:F10)/(D14+F14)

 

[JackDanIce]

You have 6 rows with "Operator" against them and just 1 row for other.

It should be giving a higher percentage against the total of all values (D14+F14) on the values shown

=SUMIFS($C$6:$C$11,$D$6:$D$11,"Operator",$F$6:$F$11,"Operator")/(D14+F14)

 

[zone709]

I agree shold be 90% =SUM(D6:D10,F6:F10)/(D14+F14) The formula above though brings back 0. I think I only need Operator once in there no? referring to Column B