Excluding empty cells in the SUMIFS formula
Solved
remy
-
remy -
remy -
Hello,
In a data range G11:G1000, I only have the 3 values RF, RF, and AZ for example in the first 3 rows.
I enter the formula below to get the values different from RF while excluding empty cells:
=COUNTIFS($G$11:$G$1000,"<>RF",$G$11:$G$1000,"<>""")
And I get back 988 :( while I would expect 1 as a result in this example.
Could someone tell me where the error is, please?
Thank you in advance!
Configuration: Windows / Internet Explorer 11.0
In a data range G11:G1000, I only have the 3 values RF, RF, and AZ for example in the first 3 rows.
I enter the formula below to get the values different from RF while excluding empty cells:
=COUNTIFS($G$11:$G$1000,"<>RF",$G$11:$G$1000,"<>""")
And I get back 988 :( while I would expect 1 as a result in this example.
Could someone tell me where the error is, please?
Thank you in advance!
Configuration: Windows / Internet Explorer 11.0
