Hey all need help with a sumproduct formula.
I am doing my company's expense report. The expenses are broken down by the pay period the expense was paid, the amount, the code which the expense is under, the name of the code, and the department the expense goes to. (Attached document)
For some reason my Sumproduct formula is not working I keep getting $0 when there is suppose to be another number
=SUMPRODUCT(--($A$1:$A$14>=$G$2),--($A41:$A$14<=$G$3),--($C$1:$C$14="530"),--($C$1:$E$14="M"),--($B$1:$B$14))
But when I use this other formula to get the total of all billable and all NonBillable It works
=SUMPRODUCT(--($A$1:$A$14>=$G$2),--($A$1:$A$14<=$G$3),--(D1:$D$14="Billable")--($E$1:$E$14="M"),--(B1:B14))
Does the formula not like specifc numbers to look for or is it something else?
Thanks
Bookmarks