Hi,
Try this
=countif(H2:H900,"Yes")/counta(H2:H900). Format this as a %age.
Have assumed that headers are in row 1.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Jbrose31" wrote in message
...
I have an excel document with a list of names and addresses of whom I've
recently sent a direct mail campaign too. I have a total of 10 rows (A-J).
I
titled Column H "responses", in which I enter "Yes" if I received a
response
and left blank if I did not receive a response.
I want to now create a formula that calculates a total response %. E.G.
900
total leads, 9 responses equals 1% response rate. I need the formula to
recognize the "Yes" entered in Column H, take the total and divide that by
the total number of leads (or rows excluding row 1 used for titles).
I really don't have the slightest clue on how to create this formula. I
hope
someone can help.
Thanks!