ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER

  • Thread starter Thread starter lorik
  • Start date Start date
L

lorik

Hi,
I'm trying to formulate a total from 2 columns. Column A has my item
letters(I have multiples), ex(B), and column B has the number of units. My
new column I'm trying to total how many units I've sold of each item.


Can you supply the right formula to use?
 
Hi lorik

Follow this example:

A1= Car, A2= Land, A3=Car, A4=House, A5=Car

B1=14, B2=6, B3=11, B4=4, B5=10

Suppose you want to put products’ name in column D and totals in column E
D1=Car, E1=SUMIF(A1:A5;"=Car";B1:B5)

D2=Land, E2=SUMIF(A1:A5;"=Land";B1:B5)

D3=Land, E3=SUMIF(A1:A5;"=Land";B1:B5)
 
Back
Top