kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 928
- Office Version
- 365
Hi,
I have the following table:
I am trying to calculate the average trades per day. In the above table, there is a total of 10 trades. (9 winning trades and 1 losing trade). The number of days is 4. Therefore, the average trade per day is 2.5. I am trying to use the following formula to derive the average number of trades per day and its not working as it results in 3.33 instead of 2.5. Appreciate all help.
I have the following table:
Book1 | |||||
---|---|---|---|---|---|
B | C | D | |||
2 | Date | Profit | Loss | ||
3 | 13-Dec | 25 | |||
4 | 13-Dec | 36 | |||
5 | 13-Dec | 12 | |||
6 | 13-Dec | 47 | |||
7 | 13-Dec | 58 | |||
8 | 14-Dec | 54 | 12 | ||
9 | 15-Dec | 36 | |||
10 | 16-Dec | 25 | |||
11 | 16-Dec | 14 | |||
Sheet1 |
I am trying to calculate the average trades per day. In the above table, there is a total of 10 trades. (9 winning trades and 1 losing trade). The number of days is 4. Therefore, the average trade per day is 2.5. I am trying to use the following formula to derive the average number of trades per day and its not working as it results in 3.33 instead of 2.5. Appreciate all help.
Excel Formula:
=COUNT(C3:C11,D3:D11)/(MAX(B3:B11)-MIN(B3:B11))