Something like this should work fine:
=SUMPRODUCT((B1:B4=123)*(C1:C4="XD"),A1:A4)
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"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