Better than Counta

Topic

New Reply

I want to count whether every other cell has an entry or not. I can do this…

COUNTA(C4,E4,G4,I4)

But that gets rather long when dealing with 25 columns. I tried this… but am not getting the results I thought I should

COUNTA(MOD(COLUMN(C4:AZ4),2),C4:AZ4)

Can someone point me in the right direction?

TIA.

Dennis

Reply | Quote

Replies

Try this (adjust the range as necessary)

=SUMPRODUCT(–(MOD(COLUMN(A1:H1),2)=0),–(A1:H1″”))

Reply | Quote

Try this (adjust the range as necessary)

=SUMPRODUCT(–(MOD(COLUMN(A1:H1),2)=0),–(A1:H1″”))

This does the trick. Thanx so much

Reply | Quote