| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
Take a look SUMIF function in help menu
"lorik" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER
Hi,
Try to work with pivot tables. Drag column A to the rows area and column B to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "lorik" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| worksheet columns changed from letter to number, how change back | New Users to Excel | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Linear Mode
