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
|