| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of cells under a condition
I have data in the range A1:K2000. In column C I have descriptions for
different types of business expense. In column G I have the amounts of these expenses. I want a formula that searches column C for a specific business expense and when finding it, adds up all the related values in column G. How do I do this? -- Thank you, Colin. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells with condition | Excel Worksheet Functions | |||
| Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
| Hiding cells on condition | Excel Worksheet Functions | |||
| sum of a cell if 2 cells meet a condition | Excel Worksheet Functions | |||
| How to add cells wiht the condition of the former cell. | Excel Discussion (Misc queries) | |||
Threaded Mode
