Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
Dear all
I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
One way:
=SUMIF(A:A,"Blue",B:B) In article , Ricardo wrote: Dear all I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
Maybe:-
=SUMIF(A1:A10,"Blue",B1:B10) Mike "Ricardo" wrote: Dear all I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
.... no
give me a error between the A10;"Blue";B1 thanks "Ricardo" escreveu: Dear all I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
Hi,
What error? What formula did you enter? Mike "Ricardo" wrote: ... no give me a error between the A10;"Blue";B1 thanks "Ricardo" escreveu: Dear all I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
mike
I already foud the cause of the error. thanks for you help "Ricardo" escreveu: Dear all I need your help please. I need to sum the values of a columm with a condition of the other columm ex: A B Blue 100 Red 200 Blue 150 Blue 180 So what I need is the sum of columm B of the "blue" in columm A Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
SumProduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |