Results 1 to 8 of 8

Countifs Simplification

Threaded View

Eusoj Countifs Simplification 06-10-2020, 04:57 AM
Richard Buttrey Re: Countifs Simplification 06-10-2020, 05:11 AM
Eusoj Re: Countifs Simplification 06-11-2020, 12:26 AM
AliGW Re: Countifs Simplification 06-10-2020, 05:14 AM
Eusoj Re: Countifs Simplification 06-11-2020, 12:22 AM
AliGW Re: Countifs Simplification 06-11-2020, 12:26 AM
Eusoj Re: Countifs Simplification 06-11-2020, 12:32 AM
AliGW Re: Countifs Simplification 06-11-2020, 01:18 AM
  1. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,777

    Re: Countifs Simplification

    Because you want to count "J" in the odd rows where the even rows immediately above them contain "Q".

    $K$5:$K$347,"J" - odd rows (5, 7, 9, etc.)

    $K$4:$K$346,"Q" - even rows (4, 6, 8, etc.)

    Excel 2016 (Windows) 32 bit
    H
    I
    J
    5
    All
    Even
    Odd
    6
    Q
    Q
    7
    J
    J
    8
    Q
    Q
    9
    J
    J
    10
    Q
    Q
    11
    J
    J
    12
    Q
    Q
    13
    X
    X
    14
    Y
    Y
    15
    J
    J
    Sheet: Records (2)
    Last edited by AliGW; 06-11-2020 at 01:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Simplification If/Or/And/Then/Else
    By snuffnchess in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2016, 08:27 PM
  2. [SOLVED] Formula Simplification
    By brharrii in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2013, 10:46 AM
  3. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  4. Formula Simplification
    By nanocrazy in forum Excel General
    Replies: 2
    Last Post: 04-16-2010, 03:14 AM
  5. if statement Simplification
    By sk81681 in forum Excel General
    Replies: 16
    Last Post: 06-05-2009, 05:24 AM
  6. [SOLVED] Simplification help
    By Mike Smith NC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2006, 01:35 PM
  7. [SOLVED] Simplification help
    By Mike Smith NC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-12-2006, 11:05 AM

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