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:

=SUMPRODUCT(('Weekly Activities'!$B$15:$B$10054='Activities Summary'!$B9)*('Weekly Activities'!$J$15:$J$10054>='List 2'!$T$2)*('Weekly Activities'!$J$15:$J$10054<='List 2'!$T$3)*'Weekly Activities'!$O$15:$O$10054)

Secondly, the formula in that column:

=IF('Prospect Pipeline'!$S13="Customer",'Prospect Pipeline'!X13,"")

will need to be changed to:

=IF('Prospect Pipeline'!$S13="Customer",'Prospect Pipeline'!X13,0)

to maintain the numerical values required.