andrewmurray86
New Member
- Joined
- Jun 18, 2020
- Messages
- 29
- Office Version
- 2016
- Platform
- Windows
Hi all,
This is my first post here:
I'm attempting to identify the smallest number within a column. I have a series of sheets with a column that's filled with profit from forex trades.
The formula is here
=MIN(IF(O4:O254<0,MIN(O4:O254),O4:O254))
It is working fine to give the largest loss
I have an overview sheet also which has more data in the columns and I need to exclude some figures from the calculation, they are giving skewed results
=COUNTIFS(F2:F252,"isnumber", N2:N252, MIN(IF(N2:N252<0,MIN(N2:N252),N2:N252)))
Please note that the N/O column difference is only due to the way the information is displayed, the
Essentially I am trying to exclude the any rows from the calculation if the cell in F is blank.
The current formula returns a $0.00 value but that's not correct.
Any assistance would be wonderful and very appreciated.
This is my first post here:
I'm attempting to identify the smallest number within a column. I have a series of sheets with a column that's filled with profit from forex trades.
The formula is here
=MIN(IF(O4:O254<0,MIN(O4:O254),O4:O254))
It is working fine to give the largest loss
I have an overview sheet also which has more data in the columns and I need to exclude some figures from the calculation, they are giving skewed results
=COUNTIFS(F2:F252,"isnumber", N2:N252, MIN(IF(N2:N252<0,MIN(N2:N252),N2:N252)))
Please note that the N/O column difference is only due to the way the information is displayed, the
Essentially I am trying to exclude the any rows from the calculation if the cell in F is blank.
The current formula returns a $0.00 value but that's not correct.
Any assistance would be wonderful and very appreciated.