Best way to count these?

  • Thread starter Thread starter Ed
  • Start date Start date
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
 
Ed
Look up the COUNTA function in Help. It counts the number of occupied
cells in a range. HTH Otto
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproducting counting blanks 4
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Counting unique values in multiple columns 4
If andf countif 1
Countif, index and match 2
count runlengths 6
Count Values in a Range, Not Formulas 2
How to count cells with conditional formatting 3

Back
Top