HI
I have the formula {=SUM(COUNTIF(BA69:BC83;$A$2:$F$2))} which counts how many values in $A$2:$F$2 are found in an area (BA69:BC83) ..and it works
I should modify it so that the number of occurrences found is returned and if there are none, instead of returning 0 (zero) it returns the letter 'x'... I tried to modify it :
=IF(SUM(COUNTIF(BA69:BC83,$A$2:$F$2))>0;"=(SUM(COUNTIF(BA69:BC83,$A$2:$F$2))";" x")
...without success,
any suggestions to use in excel 2021 ? Thank you
I have the formula {=SUM(COUNTIF(BA69:BC83;$A$2:$F$2))} which counts how many values in $A$2:$F$2 are found in an area (BA69:BC83) ..and it works
I should modify it so that the number of occurrences found is returned and if there are none, instead of returning 0 (zero) it returns the letter 'x'... I tried to modify it :
=IF(SUM(COUNTIF(BA69:BC83,$A$2:$F$2))>0;"=(SUM(COUNTIF(BA69:BC83,$A$2:$F$2))";" x")
...without success,
any suggestions to use in excel 2021 ? Thank you