Conversion Rate Calculation (Formula)

[HappyKrity]

Hi There,

I just figured something out on my own that I'd like to share with anyone who might need this info.

I was trying to determine the Conversion Rate for the # of leads I got and the # of files I was submitting (this is good for sales people).

So my calculation is: SUBBIES / LEADS = CONVERSION RATE

Another way of explaining that calculation is: Quantity of Submissions divided by Quantity of Leads equals Conversion Rate (as a percentage).

For Subbies (Submissions) and Leads I used the Icon formatting in a way that a green checkmark replace the number 3 that I entered into the cell.

So I needed a formula that would count all the 3's in a range of cells and then divide the total with the total of 3's in another range of cells.

(COUNTIF A5:A25,3) will find all cells containing the number 3 in the range of A5 through A25.

FORMULA =((COUNTIF A5:A25,3)/(COUNTIF B5:B25,3))

So I had 5 green checkmarks for my Subbies column (A) and 25 green checkmarks for my Leads column (B) which equals a conversion rate of 20%.

I hope this information is helpful for someone out there.