The following formula has worked like a charm for several years:

=CONFIG!$A$48-SUMPRODUCT(--(INDIRECT(Reconciled)=""),--(INDIRECT(AccountType)="Credit Card"),--(INDIRECT(Description)"Kohl's"),         INDIRECT(Expenses)-INDIRECT(Deposits))
However, I changed it today to test for two conditions within the same column, as follows:

=CONFIG!$A$48-SUMPRODUCT(--(INDIRECT(Reconciled)={"","C"}),--(INDIRECT(AccountType)="Credit Card"),--(INDIRECT(Description)"Kohl's"),         INDIRECT(Expenses)-INDIRECT(Deposits))
The new formula is resulting in a #VALUE! error. However, not only does the first formula work fine, I can change it to test for "C" only and it also works fine. What am I overlooking?

Thanks,

Opv