Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try this (adjust the range as necessary)

    =SUMPRODUCT(--(MOD(COLUMN(A1:H1),2)=0),--(A1:H1<>""))

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by mbarron View Post
    Try this (adjust the range as necessary)

    =SUMPRODUCT(--(MOD(COLUMN(A1:H1),2)=0),--(A1:H1<>""))

    This does the trick. Thanx so much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •