Thread: adding one less every time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default adding one less every time
=COUNTIF(C$5,"YES")+90-ROW(A1)
and copy down.
--
David Biddulph

"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



Reply With QuoteReply With Quote