summing values from adjacent column with refrence from adjacent column

sup pros

i have this info

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

&

B1: 26.20
B2: 76.00
B3: 26.21
B4: 81.45
B5: 26.20
B6: 26.19
B7: 30.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 ?

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

HTH
Kostis Vezerides

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)

"vezerid" <[email protected]> wrote in message
news:[email protected]...
> =SUMPRODUCT(C1:C8*--(A1:A8="MSFT")*--(B1:B8=26.20))
>
> HTH
> Kostis Vezerides
>

worked fine

vezerid
thank you

Bob Phillips

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

"Pivotrend" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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