Calculate a close ratio
 

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?

Calculate a close ratio
 

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

"tin95" wrote:

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?

Calculate a close ratio
 

[(closed quotes)*100]/(total quotes)
give a number that is the percentage of closed quotes)

"tin95" wrote:

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?