I need to add up dollar amounts in Column D when Columns A and B meet certain
critieria and Column C meets either of two conditions. The following should
return 300

A B C D
Open Alabama Closed 100
Open Georgia Verbal 200
Open Alabama Verbal 100
Open Alabama
Open Alabama Verbal 100

I can do it with Column C meeting 1 condition, but can't figure out how to
include the other condition.

=SUMPRODUCT(IF(A2:A6="Open",IF(B2:B6="Alabama",IF( C2:C5="Verbal",D2:D6)))
works BUT

I need to add the condition "If C2:C6="Closed". i.e. I want to sum the
dollar amounts for all Open Accounts in Alablama that are either Closed or
Verbal. Sometimes Columns C and D are blank. Thanks, Anne M