| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i add a column of values based on another column in excel
I am doing up a minor budget scheme and I am a little stuck on this one.
I have 2 columns. First column is an amount and the second column has different they type of amount of the first column. eg: Cell A1 = 700 Cell A2 = 200 Cell A3 = 150 Cell B1 = "Amount 1" Cell B2 = "Amount 2" Cell B3 = "Amount 1" What I am looking for is a way to add up the values of Column A by the type defined in Column B. Could you help? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i add a column of values based on another column in excel
Look at SUMPRODUCT. See here for more info:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html Dave -- Brevity is the soul of wit. "Zaebos" wrote: I am doing up a minor budget scheme and I am a little stuck on this one. I have 2 columns. First column is an amount and the second column has different they type of amount of the first column. eg: Cell A1 = 700 Cell A2 = 200 Cell A3 = 150 Cell B1 = "Amount 1" Cell B2 = "Amount 2" Cell B3 = "Amount 1" What I am looking for is a way to add up the values of Column A by the type defined in Column B. Could you help? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i add a column of values based on another column in excel
=SUMIF(B1:B100,"Amount 1",A1:A100)
"Zaebos" wrote: I am doing up a minor budget scheme and I am a little stuck on this one. I have 2 columns. First column is an amount and the second column has different they type of amount of the first column. eg: Cell A1 = 700 Cell A2 = 200 Cell A3 = 150 Cell B1 = "Amount 1" Cell B2 = "Amount 2" Cell B3 = "Amount 1" What I am looking for is a way to add up the values of Column A by the type defined in Column B. Could you help? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
| excel trying to sum a column of calculated values | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Linear Mode
