SUMIF Using Criteria From Two Columns

I have column -A- that contains different dates formated in the Aug-07 format, column -B- that contains the letters A,D,L ans O, and column -C- that contains dollar values.

I want to add up the dollars values in column -C- but only when -A- equals Oct-07 and -B- equal the letter "A".

I've tried SUMIF but can't seem to get it to work. Any suggestions?

Thank you for your help.

You Wrote: I want to add up the dollar values in column -C- but only when -A- equals Oct-07 and -B- equal the letter "A".

= SUMPRODUCT( --(A2:A9 = Date1), --(B2:B9="A"), C2:C9)

I assume that col A has dates in it (not just text "Oct-07") so you need to do the comparison with a real date in place of Date1

The "--" in front of the conditionals changes the values True/False into numeric 0 or 1 for the internal multiplication that SumProduct does. If either comparison is False, then there is a 0 in the multiplication with result 0. The only rows getting into the sum are the ones where both conditions are True.

Thank you. I'll give it a try.