Results 1 to 6 of 6

How to count rows based on cell value?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    How to count rows based on cell value?

    Hello everyone, I have a formula in column "I"
    IF(ROWS($2:2)<=$M$4,ROWS($2:2),"")
    that works but now I need to make changes to it.

    I want the same idea applied except if the value on column "H" is not CBA, then count up to the value in M4. If the value = CBA then count up to the value in M6. I did try on column "J"
    =IF(AND(H2<>"CBA",ROWS($2:2)<=$M$4),ROWS($2:2),"")
    but that did not return what I want (see column K for what formula should return). Any ideas on other ways I can approach or fix this?
    Attached Files Attached Files
    Last edited by AccountingJ; 02-09-2021 at 11:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to count rows based in numerical order based on cell values?
    By AccountingJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2019, 04:59 PM
  2. [SOLVED] How to count rows based in numerical order based on cell values?
    By AccountingJ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-14-2019, 10:54 PM
  3. [SOLVED] How to count rows based on cell value.
    By AccountingJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2019, 09:09 AM
  4. Insert rows based on the count in another cell
    By Shareez Saleem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2017, 05:59 AM
  5. Insert rows based on the count in another cell
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2017, 04:02 AM
  6. [SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result
    By wliang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 02:45 AM
  7. Insert Rows Based on Cell Count
    By PY_ in forum Excel General
    Replies: 2
    Last Post: 10-29-2010, 10:52 PM

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