Estimate number of emails to be send

[CD27]

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

 

[Sean Timmons]

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]

Thanks Sean...works like a charm