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


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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