Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Need help creating a formula to track % of total responses

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default Need help creating a formula to track % of total responses

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default Need help creating a formula to track % of total responses

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Questinaire with filtered responses EddS Excel Worksheet Functions 3 August 26th 08 01:21 PM
formula to count number of two different non-numeric responses cookie's mom Excel Discussion (Misc queries) 8 April 24th 08 12:12 PM
Creating a formula to show year to date total. bammiesandy Excel Discussion (Misc queries) 4 January 9th 07 10:17 PM
Creating a formula that calculates a total cell Growers Excel Discussion (Misc queries) 4 August 1st 06 09:47 PM
keeping track of total dollar amount for campers CampFriendNeedsHelp Excel Discussion (Misc queries) 4 July 9th 05 04:31 AM


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"