Quote:
Originally Posted by JPP
This is a basic example, but there is too much information in the original file to attempt to change it.... Thanks AGAIN though spencer!!
|
Try the below formula in D10 on the Totals sheet of your example.
=SUMPRODUCT((Leads!A2:A9=Totals!D7)*(Leads!B1:L1= F7)*(Leads!B1:L1<=G7),Leads!B2:L9)
Is that of help?
You'll need to tinker with it to fit your real workbook, but the idea is there and should make sense.