ExcelBanter - Summing Results Based On A Specific Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Summing Results Based On A Specific Date (https://www.excelbanter.com/excel-worksheet-functions/448036-summing-results-based-specific-date.html)

JPP

Summing Results Based On A Specific Date

I need a count total of leads assigned. However, I need to be able to do this via three dropdowns. One for AGENT NAME, as well as beginning and end date.

After choosing an agent name, begin & ending date from a drop down, I need to total how many leads they were given in the chosen amount of time.

3 Dropdowns. 1 Cell To Display Results. Info pulled from second tab.

Dates are in the following format : 1/2/2013

Thanks!

Spencer101

Quote:

Originally Posted by JPP (Post 1608773)

Hi JPP,

Any chance of you posting an example workbook? Makes it MUCH easier to provide you with solutions.

JPP

1 Attachment(s)

Quote:

Originally Posted by Spencer101 (Post 1608775)

Hi JPP,

Any chance of you posting an example workbook? Makes it MUCH easier to provide you with solutions.

This is a basic example, but there is too much information in the original file to attempt to change it.... Thanks AGAIN though spencer!!

Spencer101

Quote:

Originally Posted by JPP (Post 1608776)

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.

JPP

Thanks Spencer! That's the 2nd time you been able to solve my problem!

Spencer101

Quote:

Originally Posted by JPP (Post 1608801)

Thanks Spencer! That's the 2nd time you been able to solve my problem!

Always a pleasure, never a chore :)

All times are GMT +1. The time now is 06:18 AM.