Seifeddine87
Board Regular
- Joined
- Sep 7, 2015
- Messages
- 128
- Office Version
- 2016
- 2011
- 2010
hi i have been trying to do this for few hours and i just give up i know you gays you could do it with your eyes closed
1) i want to know how many Specific item has been sold in Specific Date Range
2) i want to know total profit in Specific item has been sold in Specific Date Range
Example
<tbody>
</tbody>
1) i want to know how many Specific item has been sold in Specific Date Range
2) i want to know total profit in Specific item has been sold in Specific Date Range
Example
A | B | C | D | E | F | G | H | I | |
1 | Code | Date | Stock No | Profit | Start Date | End Date | |||
2 | 3119 | 05/04/19 | 40 | 55 | 01/04/19 | 01/05/19 | |||
3 | 4495 | 05/04/19 | 75 | 56 | |||||
4 | 4497 | 05/04/19 | 40 | 452 | Stock No | Sold items | Profit | ||
5 | 4662 | 06/04/19 | 54 | 12 | 40 | =????? | =????? | ||
6 | 3580 | 07/04/19 | 45 | 25 | 75 | 1 | 56 | ||
7 | 4446 | 08/04/19 | 45 | 120 | 45 | 2 | 145 | ||
8 | 3783 | 08/05/19 | 45 | 30 | 54 | 1 | 12 | ||
9 | 1552 | 08/05/19 | 40 | 38 | |||||
10 | 8556 | 08/05/19 | 75 | 75 |
<tbody>
</tbody>