Best way to count these?

E

Ed

I hope someone can point me in the right direction to count whether certain
cells have a value. Beginning in Column C, every fourth column (C, H, L,
etc) out to Column DH may or may not have a value. I would like to count
how many do have a value in each data row. Is there a formula that will do
this? Or should I look at a macro?

Ed
 
O

Otto Moehrbach

Ed
Look up the COUNTA function in Help. It counts the number of occupied
cells in a range. HTH Otto
 
B

Bob Phillips

=SUMPRODUCT(--(MOD(COLUMN(C2:DH2),4)=3),--(C2:DH2<>""))

BTW, I make every fourth C, G, K, etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top