i work for comcast as a contractor need help with a formula to find out my
save %

saves,cancels, disco

so i get 67 jobs i save 22 have 24cancel and i turn off 21 sub

so its 22+24???? and how would the formula look in code

"elfenlord" wrote:

i work for comcast as a contractor need help with a formula to find out my
save %

saves,cancels, disco

so i get 67 jobs i save 22 have 24cancel and i turn off 21 sub

so its 22+24???? and how would the formula look in code


=SUM(C17:I17) is my saves
=sum(c24:I24) is my cancels
=SUM(C25:I25)is my disco

On Jul 1, 11:20 pm, elfenlord
wrote:
i work for comcast as a contractor need help with a formula
to find out my save %
[....]
so i get 67 jobs i save 22 have 24cancel and i turn off 21 sub
so its 22+24???? and how would the formula look in code

=SUM(C17:I17) is my saves
=sum(c24:I24) is my cancels
=SUM(C25:I25)is my disco

If you are counting only "saves", then:

=sum(C17:I17) / sum(C17:I17,C24:I24,C25:I25)

If you are counting "cancels" as well as "save", then:

=sum(C17:I17,C24:I24) / sum(C17:I17,C24:I24,C25:I25)

or

=1 - sum(C25:I25) / sum(C17:I17,C24:I24,C25:I25)

Be sure to format the result as Percentage with some number of decimal
places (e.g. 2). Right-click on Format Cells Number Percentage.

PS: For future note, it is prudent to start a new thread with a
distinctive subject. Otherwise, your question might go unnoticed.

Perhaps when some of the mind readers come along they will know but I for
one don't understand what it is you are asking. Would you care to explain a
bit more fully?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"elfenlord" wrote in message
...
i work for comcast as a contractor need help with a formula to find out
my
save %

saves,cancels, disco

so i get 67 jobs i save 22 have 24cancel and i turn off 21 sub

so its 22+24???? and how would the formula look in code