| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a column based on criteria from 2 other columns
Hi,
As an alternative, you can also use the following array formula (Ctrl+Shift+Enter) =sum(if((rangeA=2)*(rangeB=75),rangeC)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "cudan" wrote in message ... Column_A Column_B Column_C 2 75 250 2 75 500 3 76 350 4 70 1000 I want to add up column C, if column_A = 2 and column_B = 75. Can someone help me out with this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding data in columns based on criteria in more than one column.. | Excel Worksheet Functions | |||
| Count based on criteria from two different columns | Excel Discussion (Misc queries) | |||
| sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
| sumproduct 2 columns based on criteria in 3rd column | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
