adding one less every time

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

=COUNTIF(C5,"YES")+(89)
=COUNTIF(C5,"YES")+(88)
how do continue this for the next 87 cells adding one less every time
 
You didn't say if c5 is a CONSTANT. If so, copy down
=COUNTIF($C$5,"yes")*90-(ROW(A1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1 less for every row 4
Return duplicate max values in same cell 2
Formula HELP!! 1
Duplicate max values in one cell required 2
COUNTIF Cells in Range? 4
Transpose between sheets 4
Formula referring to another formula 2
Datavalidation with shrinking non blank values 1

Back
Top