formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...


=SUM(C17:I17) is my saves
=sum(c24:I24) is my cancels
=SUM(C25:I25)is my disco
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
Click to expand...

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

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.
 
Back
Top