Evening,
I am trying to find a formula that auto-sums a value based on matching numbers in 2 seperate columns, if the number appears more than once the value multiples accordingly.
Column A has only 18 random numbers A1:A18, Column B has 1-100 random numbers B1:B100, Column C has the $ value of 1-100 numbers in B1:B100, Column D1:D100 then sums C1:C100 based on matching numbers in A:A & B:B once, twice or however many.
I tried =IF and it will SUM once but not any more a number shows up more than once in A1:A18.
Thanks for any assistance
Bookmarks