Counting on Two conditions

RFJ · Apr 22, 2004

I wish to sum the answers in Column C providing conditions in Columns A and
B are met.

eg in the following example

Fred A 120
John B 200
Fred B 400
Fred A 50

The english would be SUMIF((Column A ="Fred")AND(Column B="A")),Column C)

The answer would be 170.

TIA

Frank Kabel · Apr 22, 2004

Hi
use
=SUMPRODUCT((A1:A100="Fred")*(B1:B100="A"),C1:C100)
or alternative syntax:
=SUMPRODUCT(--(A1:A100="Fred"),--(B1:B100="A"),C1:C100)

You may also consider using a pivot table for this kind of
reports. See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Counting on Two conditions

RFJ

Frank Kabel