=SUMPRODUCT(--(B1:B5="c"),--(C1:C5<0),--(A1:A5))
Regards,
Alan.
"pooposa" wrote in
message ...

Please help me on the following problem.

column A is equipment purchase price
column B is type of equipment, such 'c' for computer, 's' for software,
'f' for furniture
column C is the monthly depreciation value

question:
to sum up each equipment purchase prices if the monthly depreciation
value is not zero.

Example:
columnA Column B Column C
$5000 c $0
$3000 c $50
$6000 f $100
$6000 c $100
$9000 f $0

I need to sum up computer purchased for this month which should be
$3000+6000 = 9000 and furniture purchased for this month is $6000.

Thanks.


--
pooposa
------------------------------------------------------------------------
pooposa's Profile:
http://www.excelforum.com/member.php...o&userid=37122
View this thread: http://www.excelforum.com/showthread...hreadid=568548