Sumproduct = not working the way I want : )

I've highlighted in red a category that I'm trying to get to do a sumproduct based on three criteria:

1. Branch - column b
2. greater than dates of beginning of week (list 2, cell T3)
3. less than dates of end of week (list 2, cell T4)


My forumula keeps returning 5 when it should return 25. Any suggestions?

Assuming you want to sum up the "Apps Taken" on the "Weekly Activities" sheet, you will want to add that column to the formula:

Please Login or Register  to view this content.

Secondly, the formula in that column:

Please Login or Register  to view this content.

will need to be changed to:

Please Login or Register  to view this content.

to maintain the numerical values required.