ExcelBanter - adding one less every time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - adding one less every time (https://www.excelbanter.com/excel-discussion-misc-queries/188165-adding-one-less-every-time.html)

Kevin

adding one less every time

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

Don Guillett

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))

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

David Biddulph[_2_]

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

Kevin

adding one less every time

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

All times are GMT +1. The time now is 08:43 PM.