Count Days

[kumara_faith]

Hi,

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.

=COUNT(C3:C11,D3:D11)/(MAX(B3:B11)-MIN(B3:B11))

 

[GraH]

Doesn't (MAX(B3:B11)-MIN(B3:B11) return 3 instead of 4. So maybe +1 does the trick?

 

[Rick Rothstein]

You need to add one to your subtraction... subtracting only includes one of the end points, not both of them (subtracting calculates days **between**, not total days). Try...
=COUNT(C3:C11,D3:D11)/(MAX(B3:B11)-MIN(B3:B11)+1)

 

[kumara_faith]

Thank you Rick . Appreciate it.