I have used =SUMIF to total the values contained in cells selected by one given criterion. I now need to total the values contained in cells selected by two criteria. I am using Excel 2003 so =SUMIFS is not available. Is there an Excel 2003 procedure for this situation? Thank you.

Look at =SUMPRODUCT see if that helps. MIKE http://www.skeptic.com/

Mike, Thanks you for your response; unfortunately,=SUMPRODUCT didn't work in the way I needed. I need something like "In a given range, A1:C10, if cell A1:A10 = criteria 1 and if cell B1:B10 = criteria 2, then sum the contents of cell C1:C10. Thank you.

Brian, I'm not an expert on double unary operator but here is a link that may be of help. It explains it better than I could. Also on the page is a: =SUM(IF( solution. http://www.xldynamic.com/source/xld... MIKE http://www.skeptic.com/

Are you asking to sum the cells in C1:C10 where the cells in the same Row of A1:A10 and B1:B10 match criteria 1 and 2? In other words with this data: A B C 1 1 3 10 2 2 5 11 3 1 3 10 4 2 5 11 5 1 3 10 6 2 5 11 7 1 3 10 8 2 5 11 9 1 3 10 10 2 5 11 This will return 55 when Array entered with Ctrl-Shift-Enter {=SUM(IF(A1:A10=2,IF(B1:B10=5,C1:C10)))} The non-array version is: =SUMPRODUCT((A1:A10=2)*(B1:B10=5),C1:C10) If that's not what you are trying to do, please give us an example of some data and what your expected result should be.

Mike and DerbyDad03, Thank you for your assistance and reference link; the correct use of =SUMPRODUCT solved the problem.