Colunting Blank Cells

[ray963]

Hi All,

What I want is when cells A2 & B2 are blank, then 1 is counted in the Total Column.

What I then want to now achieve on top of this function is when cell value of C2 & D2 are also blank, then another 1 is added into the Total Column.

The same will occure for cells E2 & F2 giving a total of 3 in the end column.

I want to count two blank cells as 1.

Thanks

Ray

[Blake 7]

As per your example

in G2:

=COUNTBLANK(A2:B2)-1

Copied down