Jul 14 2021 06:01 AM
I am trying to use CountIF function. My data I am trying to count has periods in the text i.e. A.9.1.1
When I hard code the criteria the function works =COUNTIF(Rsk2Ctl!B2:B112,"A.9.1.1")
But when I try to program the if does not work =COUNTIF(Rsk2Ctl!B2:B112,A102)
Why
Jul 14 2021 06:11 AM
Jul 14 2021 06:22 AM
I attached spread sheet and consolidated data into one sheet.
Row 102 show how the reference to I102 does not work but when hard coded "A.9.1.1" it does
Jul 14 2021 06:36 AM
Jul 14 2021 06:38 AM
The values in column I all have a space at the end, but the values in columns B to H don't.
Select column I.
Press Ctrl+H to activate the Replace dialog.
Enter a space in the 'Find what' box and leave the 'Replace with' box empty.
Click 'Replace All'.
The formula in J102 will now work.