Hello,

I am trying to figure out how to sum data using with date range as one of the variables. Col A has my customer name and across row 1 are my dates. I want to see how much each customer purchased between 2 given dates.

Here is how my data looks

customer 6/1/16 6/2/16 6/3/16 6/4/16
customer1 5 10 10 0
customer2 50 140 150 10
customer3 57 140 160 70
customer4 15 430 340 32

So say I want to know how much customer 1 spent between 6/1/16 and 6/3/16

Any thoughts?

Thanks!