| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count the number of cell based on the value of certain cell
Dear sir,
There is 1 data set is assumed running in A1 down, viz.: In A1 down is: 22, 21, 20, 19, 18, 17 and 16 In the cell of B7 is 1 and B1 to B6 is empty (no value). My question is that I need a formula which can count from 1 in the cell of B7 and result show in B1 is 7; the result in B1 will be 10 if 5 is in the cell of B7. I tried to use COUNT() function, but the result won't change if I change the value in the cell of B7. Do you think an Excel function can achieve the result according my requirement? Many thanks, Wilchong -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| select cell based on a number in another cell | New Users to Excel | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| "count if" function based on value of another cell | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
