Add formula.

[RDx]

Im looking for a formula, that would add the values depending on what category they are in.

Colum A has the value and Colum B has the categorys

so like

Value - Cat.
1 - 1
1 - 1
1 - 2
1 - 3
2 - 3
1 - 3
2 - 2

Would give me

Cat1 = 2
Cat2 = 3
Cat 3 = 4

[VBA Noob]

Hi,

Try

=SUMPRODUCT(--($B$2:$B$8=ROW(B1))*(--($A$2:$A$8)))

or

=SUMPRODUCT(--($B$2:$B$8=1)*(--($A$2:$A$8)))

then change 1 for 2 etc

VBA Noob

[RDx]

Hi,

Try

=SUMPRODUCT(--($B$2:$B$8=ROW(B1))*(--($A$2:$A$8)))

or

=SUMPRODUCT(--($B$2:$B$8=1)*(--($A$2:$A$8)))

then change 1 for 2 etc

VBA Noob

That did the trick thanx!!!

[VBA Noob]

No problem

VBA Noob