Count non-consecutive values

[Kerrigan7]

I need help counting values within a range (row), but ONLY if they are non-consecutive e.g. if I have a 1 in columns 1, 2 and 3, I don't care, but if I only have a value in column 1, column 2 is blank and there is a value in column 3, I'd like to count (or sum) them. Any ideas?

[zbor]

can you upload example workbook?

[Marcus Ahlbäck]

Hi

What about creating an additional column with the formula something like:
=if(or(isblank(A1);isblank(b1);isblank(c1));1;0).
This should get you an 1 for every row that contains blank cells
And then you could sum that column.

BR Marcus