korhan
Board Regular
- Joined
- Nov 6, 2009
- Messages
- 215
Hi everyone,
I am trying to implement a count formula using sumifs but I couldn't wrap my head around it.
I want to be able to count member depending on the code column. Anything less than or equal 3. Also, date will be another criteria.
Trickiest part is amount will be a criteria for counting the member. If the amount is negative, count member as negative and if positive just count ( add) as positive.
Any ideas?
<tbody>
</tbody>
I am trying to implement a count formula using sumifs but I couldn't wrap my head around it.
I want to be able to count member depending on the code column. Anything less than or equal 3. Also, date will be another criteria.
Trickiest part is amount will be a criteria for counting the member. If the amount is negative, count member as negative and if positive just count ( add) as positive.
Any ideas?
Date | Code | Member | Amount | |
<tbody> </tbody> | 1 | 12 | $200 | |
<tbody> </tbody> | 1 | 2 | $100 | |
<tbody> </tbody> | 1 | 123 | -$50 | |
<tbody> </tbody> | 3 | 5 | -$20 | |
<tbody> </tbody> | 1 | 6 | $25 | |
<tbody> </tbody> | 4 | 7 | -$100 | |
<tbody> </tbody> | 3 | 8 | $55 | |
<tbody> </tbody> | 2 | 6 | $23 | |
<tbody> </tbody> | 1 | 6 | $42 | |
<tbody> </tbody> | 1 | 9 | -$25 | |
<tbody> </tbody> | 5 | 10 | $25 | |
<tbody> </tbody> | 3 | 9 | $23 |
<tbody>
</tbody>