Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

external usenet poster

Posts: 10,124

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding time	GrayC011182	Excel Worksheet Functions	2	June 4th 07 08:33 PM
Adding Time	suicidal jackie	Excel Worksheet Functions	1	April 11th 06 05:18 PM
Adding time	simon, uk	Excel Discussion (Misc queries)	3	March 3rd 06 10:18 AM
Time log adding time from separate sheets	teastman	New Users to Excel	1	December 31st 05 04:14 PM
Adding time to date-time formatted cell	tawtrey(remove this )@pacificfoods.com	Excel Discussion (Misc queries)	4	August 12th 05 10:53 PM

All times are GMT +1. The time now is 01:27 AM.

About Us

"It's about Microsoft Excel"