in the attached sheet I have numbers from cell B1 to AF1..some cells are blank and some contain text.
In cell AG1 I want a formula to count the number of cells from B1 to F1 which contain values over zero and less than 0.7.
this formula can then be copied down for rows 2 and 3 etc.
Bookmarks