Countif Function

[Joe Gieder]

I'm trying to count the number of cells that are greater
than "26 wks". When I use Countif('Priced BOM'!
S3:S82,">=26 wks") I also get the cells with 3 wks, 4
wks, 5 wks, 6 wks, 7 wks and on, then I tried the formula
like this =countif(value(left('Priced BOM'!
S3:S82,2)),">26 wks") and get an error. Is there any way
to count just those which are greater than 26 without
getting 3, 4, 5, 6, 7 ... I even tried =countif(VALUE(LEFT
('Priced BOM'!S3:S82,FIND(" ",'Priced BOM'!S3:S82)-
1)),">=26"). I think I ran out of brain cells.

Any help would be greatly appreciated.

Joe

 

[EdE]

Do the cells have "wks" in them along with the number or is it a format?
If it is in the number take out the "wks" part as it turns it into
text. Then take "wks" out of the formula. It should work.

Ed

 

[Joe Gieder]

The cells do have "wks" in them and if possible I want to
leave them in there, some even say "stock" and "stk".

Joe