| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How sum values in column B using values in column A as the conditi
I want to sum the values in column B using indicators in column A as the
condition. For instance, all values in column B matching the "1" indicator in column A should be summed, and no others. Other indicators in column A are 2, 3, etc. I know this takes an array formula, but I don't remember how to do it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move column values w/o formula | Excel Worksheet Functions | |||
| Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
| Removing duplicate values in a column | Excel Worksheet Functions | |||
| Last several values in a column | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
