Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equation required
I am trying to generate an equation to generate the total value in one column
if there are two categories are same in two columns. e.g. A B C 1 a x 50 2 a y 55 3 b x 90 4 a y 69 5 b y 38 how i can generate the equation while Column A & B are matched. Regards Junaid |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equation required
?B?SnVuYWlk?= wrote in
: I am trying to generate an equation to generate the total value in one column if there are two categories are same in two columns. e.g. A B C 1 a x 50 2 a y 55 3 b x 90 4 a y 69 5 b y 38 how i can generate the equation while Column A & B are matched. Regards Junaid this formula will look for a's and y's and sum =SUMPRODUCT((A1:A5="a")*(B1:B5="y")*(C1:C5)) in this case you get 124 row2 and row4 match and get summed. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equation required
Hi,
You don't provide a very good example but there's this =SUMPRODUCT((A1:A5=B1:B5)*(C1:C5)) or this =SUMPRODUCT((A1:A5="A")*(B1:B5="B")*(C1:C5)) Mike "Junaid" wrote: I am trying to generate an equation to generate the total value in one column if there are two categories are same in two columns. e.g. A B C 1 a x 50 2 a y 55 3 b x 90 4 a y 69 5 b y 38 how i can generate the equation while Column A & B are matched. Regards Junaid |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help required | Excel Worksheet Functions | |||
Help Required | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Help required | Excel Discussion (Misc queries) | |||
VB Required?? | Excel Worksheet Functions |