Results 1 to 4 of 4

change counting range when condition

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2015
    Location
    Simeria
    MS-Off Ver
    2021
    Posts
    97

    change counting range when condition

    Hi

    i need the formula to change it's counting range when condition on column A is meet

    condition is: when on column A is 1 the counting range start from that "1"

    A
    1 =IF($B7=C$5,COUNTIF($B$7:$B7,$B7),"0")
    2 =IF($B8=C$5,COUNTIF($B$7:$B8,$B8),"0")
    3 =IF($B9=C$5,COUNTIF($B$7:$B9,$B9),"0")
    1 =if($B10=C$5,COUNTIF($B$10:$B10,$B10),"0") range changed
    2 =if($B11=C$5,COUNTIF($B$10:$B11,$B11),"0")
    3 =if($B12=C$5,COUNTIF($B$10:$B12,$B12),"0")
    4 =if($B13=C$5,COUNTIF($B$10:$B13,$B13),"0")
    1 =if($B14=C$5,COUNTIF($B$14:$B14,$B14),"0") range changed
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] counting range of cells with condition
    By blexor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2014, 05:38 PM
  2. counting blank cells in range based on condition using another column
    By TheBlueBell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2013, 04:58 PM
  3. Counting the number of empty cells based on a condition in a range
    By naga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 10:01 AM
  4. Condition Formatting: Change color when month change (oct = red, Nov = blue)
    By Flyinace2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2012, 12:20 PM
  5. [SOLVED] Counting cells that fall in a date range AND meet a Yes/No condition
    By pentatonic145 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:26 PM
  6. Counting until a condition and then, again counting from start
    By amitraiforyou in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2010, 05:25 PM
  7. auto change cell formula on condition of worksheet change in other cells
    By futurejock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2009, 12:11 AM
  8. In excel counting cells in a range which meet condition ">Xand<X"
    By Uncivil Servant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2006, 09:45 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