Forum Discussion
How to count rows based on a column that has data and whether or not an additional column is null
Hi, I'm trying to replicate a Countif function in Excel that will count the number of rows based on a item in one column, then I need to see if another column has any data or is null for that row. ...
YOu can see here in my data table the highlighted columns, I need to count how many columns have an answer in them. Row 2 has 4 answers, row 3 has 2 answers, row 4 has one answer, etc. Row 12 has zero answers
I need to find a way to simply count by row, how many of these columns have an answer. There are up to 10 columns that will have an answer. Then I need to sum up each colmn number, so like column P has 10 answers, column z has 5 answers, AJ has 4 answers, AT has 2 answers.
ryan_mayuSuper User
Anonymous
in my sample data,
select first column and unpivot other columns
in the value column, unselect null
pls see the attachment below