Hello
I want to count only the rows that contain at least one cell of data (text OR numbers), within a specified range of columns. However, I don't want to specify the range of columns using their fixed column letter names, but using the text in row 1 as the column header. (This Row 1 text is set up to be variable, so it will be different for every individual usage of the workbook that I am creating, so I can't just plug in the fixed column names)
Ideally I want a formula (rather than a Macro/VBA code) to put into a cell on another sheet and just provide a count. If I use a Macro/VBA then it will decrease the user-friendliness of the workbook I'm creating (it's a tool for my non-technical team to automate quantitative survey data analysis, with variable, but predictable, data inputs).
I have found many tips and formulas to count only the rows that contain at least one cell of data (below), but none that allow this variable column functionality
<colgroup><col style="mso-width-source:userset;mso-width-alt:9910;width:203pt" width="271"> </colgroup><tbody>
[TD="class: xl65, width: 271"] https://stackoverflow.com/questions/6867070/how-can-i-count-the-rows-with-data-in-an-excel-sheet
[/TD]
[TD="class: xl65"] https://organicweb.com.au/7877/general-technology/excel-function-instructions/
[/TD]
</tbody>
For example, the values in row 1 will read: Q1, Q2, Q3, Q3.2, Q3.3, Q3.4, Q4, Q4.2, Q5, etc., where the number of columns with decimals allocated will vary depending on previous inputs and will occupy different columns each time the workbook is used. Now, say for example I want to look at just columns relating to Q3 (so including Q3.2, Q3.3, Q3.4, etc). I am totally lost on how to do this without using fixed column names.
Any help much appreciated!
Thanks
Matt
I want to count only the rows that contain at least one cell of data (text OR numbers), within a specified range of columns. However, I don't want to specify the range of columns using their fixed column letter names, but using the text in row 1 as the column header. (This Row 1 text is set up to be variable, so it will be different for every individual usage of the workbook that I am creating, so I can't just plug in the fixed column names)
Ideally I want a formula (rather than a Macro/VBA code) to put into a cell on another sheet and just provide a count. If I use a Macro/VBA then it will decrease the user-friendliness of the workbook I'm creating (it's a tool for my non-technical team to automate quantitative survey data analysis, with variable, but predictable, data inputs).
I have found many tips and formulas to count only the rows that contain at least one cell of data (below), but none that allow this variable column functionality
<colgroup><col style="mso-width-source:userset;mso-width-alt:9910;width:203pt" width="271"> </colgroup><tbody>
[TD="class: xl65, width: 271"] https://stackoverflow.com/questions/6867070/how-can-i-count-the-rows-with-data-in-an-excel-sheet
[/TD]
[TD="class: xl65"] https://organicweb.com.au/7877/general-technology/excel-function-instructions/
[/TD]
</tbody>
For example, the values in row 1 will read: Q1, Q2, Q3, Q3.2, Q3.3, Q3.4, Q4, Q4.2, Q5, etc., where the number of columns with decimals allocated will vary depending on previous inputs and will occupy different columns each time the workbook is used. Now, say for example I want to look at just columns relating to Q3 (so including Q3.2, Q3.3, Q3.4, etc). I am totally lost on how to do this without using fixed column names.
Any help much appreciated!
Thanks
Matt
