1 less for every row
Hi Kevin
Try
=COUNT($B$4:B5,"YES")+91-ROW(A1)
--
Regards
Roger Govier
"Kevin" wrote in message
...
=COUNTIF(B4:B5,"YES")+(90)
=COUNTIF(B4:B6,"YES")+(89)
=COUNTIF(B4:B7,"YES")+(88)
How do I continue this down for 90 rows? Each row counting from B4 to
that
row, adding 1 less for every row.
|