Counting on Two conditions

[RFJ]

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]

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