**Full disclosure:**

I am by no means an expert with excel, but I do dabble and have taken a few courses in school that have focused on data analysis using excel. And I do a fair bit of excel work that can get a bit involved.

**Situation:**

A couple months ago I was conducting some trimester reporting and decided I wanted to create a spreadsheet that would summarize the values I needed to report on. This sheet would draw all its data from a larger Project Status sheet. I ran into a few problems trying to create formulas for some of the metrics I wanted numbers for, so I did some research online and found a formula that would allow me to count the number of unique entries based on a date range and which also had the same budget code. I ended up getting it work, however the data from this Project Status spreadsheet was later separated into about 4 other sheets. So, of course I figured this formula could be fixed easily by changing the cell pathways, however when everything was changed it kept reporting a value of 0 which isn’t true.

I admit I do not completely understand the formula, specifically the last part of it, so recreating it has been a bit of an issue. I made a mock example since the other is too complex and has sensitive information in it.

**For this example, I am looking to find the number of unique addresses that were visited between 12/31/2019 and 5/1/2020 and that used the budget code 301-335.**

Even when I do it here, I get 0 instead of what should be 2 (highlighted values). The formula I am using is:

=SUMPRODUCT(IF((B3:B15<=E4)*(B3:B15>=E3)*(C3:C15="301-335"), 1/COUNTIFS(B3:B15, "<="&E4, B3:B15, ">="&E3, A3:A15, A3:A15), 0))

The original formula I was trying to rework drawing from multiple sheets was as follows:

=SUMPRODUCT(IF(('Projects Approved'!$I:$I<=I3)*('Projects Approved'!$I:$I>=I2)*('Projects Approved'!$K:$K="301-335"), 1/COUNTIFS('Projects Approved'!$I:$I, "<="&I3, 'Projects Approved'!$I:$I, ">="&I2, 'Projects Approved'!$C:$C, 'Projects Approved'!$C:$C), 0))

Any help with this would be greatly appreciated, I have been almost pulling my hair out over it and it is likely something simple that I have overlooked or just don’t understand.

Thanks in advance