=SUMPRODUCT((A1:A100 = "Duncan")*(B1:B100= "Cat 1")*(C1:C100))
Regards,
Alan.
"Ken" wrote in message
...
Hi Anyone

I have the following on a spreadshhet


Col A Col B Col C
Duncan cat1 10
Duncan cat2 30
Paul cat 3 5
Craig cat 1 60
Paul cat 2 30
Craig cat3 20
Duncan cat1 23

I would like to know the formula to add column C using column A as my
first
criteria then column B as my second criteria to achieve the following
result

Duncan Cat 1 = 33
Duncan Cat 2 = 30
Paul Cat 2 = 30
And so on
All help is greatly appreciated