Countif Function

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

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
 
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
 
The cells do have "wks" in them and if possible I want to
leave them in there, some even say "stock" and "stk".

Joe
 
Back
Top