adding one less every time

[Kevin]

=COUNTIF(C5,"YES")+(89)
=COUNTIF(C5,"YES")+(88)
how do continue this for the next 87 cells adding one less every time

 

[Don Guillett]

You didn't say if c5 is a CONSTANT. If so, copy down
=COUNTIF($C$5,"yes")*90-(ROW(A1))

 

[David Biddulph]

=COUNTIF(C$5,"YES")+90-ROW(A1)
and copy down.

 

[Kevin]

c5 is either yes or no i only want it to count if it says yes