summing values from adjacent column with refrence from adjacent column

[Pivotrend]

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 ?

 

[vezerid]

=SUMPRODUCT(C1:C8*--(A1:A8="MSFT")*--(B1:B8=26.20))

HTH
Kostis Vezerides

 

[Bob Phillips]

Kostis,

You do not need * and --, one or the other, they do the same thing

=SUMPRODUCT(C1:C8,--(A1:A8="MSFT"),--(B1:B8=26.20))

or

=SUMPRODUCT(C1:C8*(A1:A8="MSFT")*(B1:B8=26.20))



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[R..VENKATARAMAN]

in an empty cell type
=SUMPRODUCT((A1:A9="MSFT")*(B1:B9=26.2)*(C1:C9))

 

[Pivotrend]

worked fine

vezerid
thank you

 

[Pivotrend]

Bob Phillips

 

[vezerid]

Bob,

thanks for the tip. I guess it is a remainder from older days, when I
was first trying similar formulas, either with SUMPRODUCT or with
SUM(IF... Having not thought of the -- conversion before joining the
newsgroups, I sometimes had to devise more elaborate conditions. Thus
some insecurity often prompts me to overdo it with conversions lol.

With this opportunity I must say that I have learned a lot of things
from your posts and continue learning. Keep up the good work!

Kostis