It should work. See this screencap:

http://img118.imageshack.us/img118/9061/sumsumifkx2.jpg

If you're getting a result of 0 then there's a problem with your data. The
numbers may be numbers formatted as TEXT or there may be unseen charactes
in column A like leading/trailing spaces.

Try this first:

Select an empty cell that hasn't been formatted or used in any way.
Copy that empty cell: EditCopy
Select the range of numbers in column D.
Then, EditPaste SpecialAddOK

Does the formula now work?


--
Biff
Microsoft Excel MVP


"soconfused" wrote in message
...
This didn't work, it gave me 0 for the answer.
--
DMM


"T. Valko" wrote:

One way:

=SUM(SUMIF(A1:A10,{"C","X"},D1:D10))


--
Biff
Microsoft Excel MVP


"soconfused" wrote in message
...
I am trying do do a sumif using 2 conditions

For example:

I want to add the values in column d if the value in column a is either
C
or
X.
--
DMM