+ Reply to Thread
Results 1 to 3 of 3

Trying to count every second cell in a column that meets certain criteria

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    london england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Trying to count every second cell in a column that meets certain criteria

    Some aspects of excel are a mystery to me!
    This probably is very simple for someone else.

    I want to analyse some data in every second cell in one column.
    What I want to do is count the number of cells that contain data that is between say, 20 and 30, but not including those numbers.
    E.g.
    A
    1 14
    2 45
    3 27
    4 32
    5 25
    6 23
    7 29
    8 9

    On this I would want to look at cells A2, A4, A6 and A8. The formula would give me an answer of 1 for my criteria.

    I have tried countif, which says I have too many arguments. Countifs says Ihave too few.

    If I use a continuous range, I can do it. It is when I try to do every second cell that I hit problems.

    Suggestions will be gratefully welcome.

    Regards

    RalphCr

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Trying to count every second cell in a column that meets certain criteria

    Assuming your data is in Range A1:B8..try this..

    =SUMPRODUCT(--(MOD(ROW(A1:A8),2)=0),--(B1:B8>20),--(B1:B8<30))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    london england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Trying to count every second cell in a column that meets certain criteria

    That would have taken me a lifetime to work out!

    It works a treat. I am very grateful!

    Regards

    Ralph

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1