=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))

Regards

Trevor


"steph" wrote in message
...
I've seen similar threads here but can't seem to get them to work...here
is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk, sum
column C. In this case, I expect 8 to be returned. I will be posting the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!