A conditional counting issue

[akotronis]

Hello everybody.

Here is an issue I am dealing with:

Column H is the key column, indicating how many "answers" can be found at each row of the yellow range. In the column I we want to count how many rows on the yellow range have 0 answers (which are the last five), how many rows on the yellow range have 1 answer (which is the first one), etc.

These can be achieved by the formulas on column I.

Now, how could this be done if we wanted the range

$C$1:$G$15

on the

MMULT(--($C$1:$G$15<>"");{1;1;1;1;1})

part of the formula be consisted only by those rows of the yellow area that have either 1 or 4 on column A? (i.e. rows 5,8,9,11)

And another question:

Is the <>"" part of the formula safe enough for this purpose, considering that we want a TRUE returned only for the cells of the range containing visible characters? (i.e. if a cell, say C11, doesn't contain a visible character and the result of C11<>"" is TRUE, then we have a bad situation).

If it is not considered to be safe, do we have any alternatives?