TheMacroNoob
Board Regular
- Joined
- Aug 5, 2022
- Messages
- 52
- Office Version
- 365
- Platform
- Windows
Hello excel gurus,
I have googled long and far and wasn't able to find the solution to this basic problem.
I am trying to COUNTIF a range is greater than (-1,000,000). I noticed the number it was resulting in was too high.
I have a lot of zeros in the table, which seem to qualify for that logical statement.
The logical operator for "not equal to" is (<>), but I don't know how to make my formula countif both greater than (-1,000,000) AND <> 0.
=COUNTIFS('Unclosed Deals - 0.95'!$DB$5:$DB$67,">"&'Summary - 0.95'!$C$45)
I was thinking something like:
=COUNTIFS('Unclosed Deals - 0.95'!$DB$5:$DB$67,AND(">"&'Summary - 0.95'!$C$45,"<>0"))
or something similar but it doesn't work. I tried "<>"&0 as well and that didn't work.
I greatly appreciate your insight.
I have googled long and far and wasn't able to find the solution to this basic problem.
I am trying to COUNTIF a range is greater than (-1,000,000). I noticed the number it was resulting in was too high.
I have a lot of zeros in the table, which seem to qualify for that logical statement.
The logical operator for "not equal to" is (<>), but I don't know how to make my formula countif both greater than (-1,000,000) AND <> 0.
=COUNTIFS('Unclosed Deals - 0.95'!$DB$5:$DB$67,">"&'Summary - 0.95'!$C$45)
I was thinking something like:
=COUNTIFS('Unclosed Deals - 0.95'!$DB$5:$DB$67,AND(">"&'Summary - 0.95'!$C$45,"<>0"))
or something similar but it doesn't work. I tried "<>"&0 as well and that didn't work.
I greatly appreciate your insight.