=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.

=COUNTIF(B$4:B5,"YES")+95-ROW(B5) and copy down
--
David Biddulph

"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.

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.

Try this:

=COUNTIF(B$4:B5,"YES")+91-ROWS($1:1)

Biff

"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.

Just another way:

=COUNTIF(B$4:B5,"YES")+ROWS(1:$90)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.