Apologies for the multiple questions today.. My brain is just not functioning!
In Row 1 (From B:G I have a cell which is either blank or non-blank)
In Cells B2:G100, these may contain a value or not.
What I need is a COUNTIF the column has a header value to count. If the column header is blank, then whatever cells are filed in or not, it ignores in the count
So the answer i need is 11
I need a formula that will dun the length of the specified columns and just return a count of one figure please.. The number of columns will increase over time, so preferably a formula that I an just change the columns i want captured, rather than one that is column B+Column C+Column D all in one formaula (if that makes sense!)
In Row 1 (From B:G I have a cell which is either blank or non-blank)
In Cells B2:G100, these may contain a value or not.
What I need is a COUNTIF the column has a header value to count. If the column header is blank, then whatever cells are filed in or not, it ignores in the count
| COLUMN B | COLUMN C | COLUMN D | |
| Header_1 | Header_2 | <blank> | |
| hhuui | wdfd | sdffs | |
| dsaf | dfssdfdfs | dfsdf | |
| dfsfsd | sdf | df | |
| dsfdf | fsf | sdfds | |
| dfasd | dfdfsah | ||
| dfsdsfdf | sdfdf | ||
| dfsdf | dfgfg | ||
| (COUNT 7) | (COUNT 4) | (COUNT 0) |
So the answer i need is 11
I need a formula that will dun the length of the specified columns and just return a count of one figure please.. The number of columns will increase over time, so preferably a formula that I an just change the columns i want captured, rather than one that is column B+Column C+Column D all in one formaula (if that makes sense!)
