I'm trying to return the number off cells that contain any variation of 23.2 as follows but can't get the correct values to return;
A
1 23.2
2 23.2
3 23.2 one
4 23.2, one
5 23.3
I've tried COUNT(A1:A5,"23.2*") and variations of these using COUNTA, COUNTIF, no wildcards, wildcards *, ? etc but none will return the value I want, in this example it should be 4.
It seems that it should be pretty simple but perhaps the mixture of no's and text is tripping it up or perhaps I'm just using the wrong formula.
Can anyone help please?
Bookmarks