| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If a cell contains a value then sum another cell.
I am trying to find a formula that can sum the value of a cell if it contains
a certain value. For example: I have 100 sales that were made and 10 sales people. Each sales person has different sales $$ volume that they done. So I want to find the TOTAL sales volume for each sales person. Their sales volume is in one column and their name is in another. I need a formula that will give me the toal volume for example sum C2 if B2 = Bob. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Threaded Mode
