I'm using the Conditional Sum Wizard to calculate sums based on text criteria.

It usually works fine except in only a few cells does it return 0 when I
know the sum is more than 0. I've rechecked formula and it appears no
different than the formulas that are working properly.

Any ideas why I'm getting 0 when it should actually be 400?

Here's the formula that I'm using. and I am pressing control+enter+shift to
make it an array formula.

=SUM(IF(Expenditures!$C$24:$C$192="Events",IF(Expe nditures!$D$24:$D$192="IA",Expenditures!$F$24:$F$1 92,0),0))
Thanks