Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Estimate number of emails to be send
I’m trying to estimate the number of people I need to pull from a
database based off certain criteria: 1. 5,000 people pulled initially from database and sent emails 2. Of those 5,000 people 4% open email 3. Of that 4% or 200 people only 27% or 54 people actually click and complete questions in email 4. 300 people needed to complete questions in email So my question is how can I write this in an excel formula to see what is the additional number of emails I need to pull above the original 5000 knowing points 2,3,4? Thanks for any help. CD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Estimate number of emails to be send
So, if you have the table with 5000 people, =counta(A:A)-1. -1 removed the
header row from your count. so, you want 300 to answer. =300/(.04*.27) substitue 300, .04 and .27 with the cells that hold those numbers "CD27" wrote: Im trying to estimate the number of people I need to pull from a database based off certain criteria: 1. 5,000 people pulled initially from database and sent emails 2. Of those 5,000 people 4% open email 3. Of that 4% or 200 people only 27% or 54 people actually click and complete questions in email 4. 300 people needed to complete questions in email So my question is how can I write this in an excel formula to see what is the additional number of emails I need to pull above the original 5000 knowing points 2,3,4? Thanks for any help. CD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Estimate number of emails to be send
Thanks Sean...works like a charm
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel send emails | Excel Worksheet Functions | |||
Slow to send emails | Excel Discussion (Misc queries) | |||
Can I use excel to send personalized emails? | Excel Worksheet Functions | |||
Can Excel send out emails? | Excel Discussion (Misc queries) | |||
send emails | Excel Discussion (Misc queries) |