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

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

Estimate number of emails to be send
 

Thanks Sean...works like a charm