How do you count the number of rows only if there is a number in a specific cell e.g
Please ignore the highlights on the cells
Once you enter a number on BJ56 it will increase the count to 5 lines on AD4 and remain 4 count if nothing is entered
Also instead of using AM52:AM5000 is there a way to not use 5000 to like AM:AM but starting from row 56
Please ignore the highlights on the cells
Ying 1.4.2.xlsm | |||
---|---|---|---|
AD | |||
3 | Play Count | ||
4 | 5 | ||
Overview |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AD4 | AD4 | =COUNT(AM52:AM5000) |
Ying 1.4.2.xlsm | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | |||
52 | 9 | 15 | 26 | 1 | 2 | 25 | 29 | 7 | 16 | 8 | 12 | 17 | 24 | 28 | 31 | 22 | 3 | 4 | 5 | 13 | 20 | 36 | 33 | |||
53 | 9 | 15 | 26 | 1 | 2 | 25 | 29 | 7 | 16 | 8 | 12 | 17 | 24 | 28 | 31 | 22 | 3 | 4 | 5 | 13 | 20 | 36 | 17 | |||
54 | 9 | 15 | 26 | 1 | 2 | 25 | 29 | 7 | 16 | 8 | 12 | 17 | 24 | 28 | 31 | 22 | 3 | 4 | 5 | 13 | 20 | 36 | 5 | |||
55 | 9 | 15 | 26 | 1 | 2 | 25 | 29 | 7 | 16 | 8 | 12 | 17 | 24 | 28 | 31 | 22 | 3 | 4 | 5 | 13 | 20 | 36 | 6 | |||
56 | 9 | 23 | 26 | 1 | 2 | 25 | 29 | 7 | 16 | 8 | 12 | 24 | 28 | 31 | 17 | 22 | 3 | 4 | 13 | 30 | 11 | 36 | ||||
Overview |
Once you enter a number on BJ56 it will increase the count to 5 lines on AD4 and remain 4 count if nothing is entered
Also instead of using AM52:AM5000 is there a way to not use 5000 to like AM:AM but starting from row 56
Last edited: