Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
slight change to Ashish's formula, since COUNTA() doesn't count blanks
=countif(h2:h900,"Yes")/rows(h2:h900) "Jbrose31" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Questinaire with filtered responses | Excel Worksheet Functions | |||
formula to count number of two different non-numeric responses | Excel Discussion (Misc queries) | |||
Creating a formula to show year to date total. | Excel Discussion (Misc queries) | |||
Creating a formula that calculates a total cell | Excel Discussion (Misc queries) | |||
keeping track of total dollar amount for campers | Excel Discussion (Misc queries) |