Sumif with conditions

[soconfused]

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.

 

[T. Valko]

One way:

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

 

[soconfused]

This didn't work, it gave me 0 for the answer.

 

[Gord Dibben]

Are the numbers in column D actually numbers?

In E1 enter =ISNUMBER(D1) and copy down.

TRUE or FALSE returned?

If FALSE, format all to General. Copy an empty cell and Paste
Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

 

[T. Valko]

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: Edit>Copy
Select the range of numbers in column D.
Then, Edit>Paste Special>Add>OK

Does the formula now work?

 

[soconfused]

Thank you so much, it was the leading/trailing spaces.

 

[T. Valko]

Glad you got it straightened out. Thanks for the feedback!