antoniog925
New Member
- Joined
- Aug 16, 2013
- Messages
- 1
Help! I'm trying to create a function where cell "a" aggregates the sums of cells 2-10 IF they meet the certain conditions in a drop down menu.
For example: I want to know exactly how much $$$ is counted for a sales pipeline IF the prospect is at 50-75% or 75%+ (options in the drop down). So I want the cell to only count the money if the user chooses a drop down menu in the adjacent column.
can this be done?
<tbody>
</tbody>
For example: I want to know exactly how much $$$ is counted for a sales pipeline IF the prospect is at 50-75% or 75%+ (options in the drop down). So I want the cell to only count the money if the user chooses a drop down menu in the adjacent column.
can this be done?
Money | Drop Down |
$1000 | 50-75% |
$200 | 75%+ |
$100000 | 10% |
SUM (IF 50% or greater from drop down) |
<tbody>
</tbody>