SUMPRODUCT is the way to go here.

=SUMPRODUCT(--($B$2:$B$100=123),--($C$2:$C$100="XD"),($A$2:$A$100))

Note, I am assuming all values in column A and column B are numbers, not text.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Rody2003" wrote:

I need to sum a column based on two different variables. For example I need
to sum Column A if Column B = 123 and Column C = XD. For the example below
the sumif formula would equal "11." I have tried creating this formula
several times but I have yet to succeed as I have always gotten some type of
error. I could use the dsum formula but I would like to stick to"if"
formulas. Any suggestions?

Col. A Col. B Col.C
1 123 XD
5 222 XD
10 123 CC
10 123 XD