Here is an array formula that will do it
Formula:
=COUNT(IF(IFERROR(--MID(SUBSTITUTE(A1," ",REPT(" ",99)),99*(COLUMN(A:Z)-1)+1,99),"")<75,--MID(SUBSTITUTE(A1," ",REPT(" ",99)),99*(COLUMN(A:Z)-1)+1,99)))
**Must be entered with Ctrl+Shift+Enter key combination.
v A B 1 18 22 90 2 2 2 33 49 65 4 3 99 45 65 79 110 63 3 4 1225 33 489 63 15 78 1300 33 8 11 3 7
Bookmarks