Is there a way to use Countif/s to count a row if the value in a field is plus or minus the value in the criteria range?
For example, I might write =COUNTIF('Sheet1'!$A$2:$A$546,'Sheet2'!H2"-80"), and I would get an error informing me that there is a problem with my formula. I also tried adding the & symbol so that I have =COUNTIF('Sheet1'!$A$2:$A$546,'Sheet2'!H2& "-80") and I get the same error result.
I know that I can use the '<', '>', '<=', '>=', or '<>' operators with countif, but what about getting an exact result if it is plus or minus the number in another cell? I just want to return a 1 or 0 if it meets my criteria, which is why I am trying countif.
Is there a better way to do this than Countif?
For example, I might write =COUNTIF('Sheet1'!$A$2:$A$546,'Sheet2'!H2"-80"), and I would get an error informing me that there is a problem with my formula. I also tried adding the & symbol so that I have =COUNTIF('Sheet1'!$A$2:$A$546,'Sheet2'!H2& "-80") and I get the same error result.
I know that I can use the '<', '>', '<=', '>=', or '<>' operators with countif, but what about getting an exact result if it is plus or minus the number in another cell? I just want to return a 1 or 0 if it meets my criteria, which is why I am trying countif.
Is there a better way to do this than Countif?
Last edited: