Calculate a close ratio

  • Thread starter Thread starter tin95
  • Start date Start date
T

tin95

I am working on a template to keep track of every quote that leaves our
office and would like to include a formula to calculate our close ratio based
on the number of accepted proposals. I have a column for Y/N but it could
easily be a check mark or something else. What are some possible formulas?
 
Hi,

Say you mark column A with a Y for hits and a N for failures, Try this in
another cell to get your close ratio

=COUNTIF(A1:A500,"y")/COUNTA(A1:A500)

format as percent
It doesn't matter if part of the range is empty but you must mark Y hits and
N (actually anything excepty blank) for misses.

Mike
 
Back
Top