Use this

=SUMPRODUCT((A2:A6="Open")*(B2:B6="Alabama")*((C2: C6="Verbal") +
(C2:C6="Closed"))*(D2:D6))

annem Wrote:
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


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566632