sup pros

i have this info

A1: MSFT
A2: CAT
A3: MSFT
A4: IBM
A5: MSFT
A6: MSFT
A7: CSCO
A8: MSFT
A9: MSFT

&

B1: 26.20
B2: 76.00
B3: 26.21
B4: 81.45
B5: 26.20
B6: 26.19
B7: 18.20
B8: 26.20
B9: 26.23

&

C1: 23,670
C2: 76.00
C3: 20,000
C4: 81.45
C5: 25,998
C6: 34,005
C7: 18.20
C8: 35,000
C9: 17,050


I want to sum up the values in column C if
only at this condition , the adjacent column (B) is at 26.20 & column
(A) is MSFT

the result would be C1 , C5 , & C8 = 23,670+25,998+35,000 = 84,668
how do i do that ?


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=518953