Calculating a sum of certain data based on other dats

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I can’t get it to work. Basically, I need a formula to say IF ‘this field is not blank’ then sum ‘this different set of data for the week following”. 

 

HELP

 

 

By: Devon

Leave a Reply

Your email address will not be published. Required fields are marked *