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)

--
MFS22


"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?