Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count number of cells
I need a formula to count the number of cells in a column that have numbers
in them and are less than 46 (or cell B2 which equals to 46), but stops at a blank cell , and then counts again how many cells have numbers in them less than 46 (or B2) but stops at the next blank cell and so on eg: A B 1 71 2 55 3 36 4 72 5 15 6 80 7 95 result 2 8 blank cell 9 17 10 22 11 90 12 35 result 3 13 blank cell 14 15 15 20 16 23 17 44 18 100 result 4 19 blank cell 20 21 21 17 result 2 22 blank cell down to 500 rows Any help will appreciated thanks bill gras bill gras |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
How do I count number of cells with info?? | Excel Discussion (Misc queries) | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |