Results 1 to 8 of 8

formula to count the instances of a type of number in cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-04-2014
    Location
    Nevada, USA
    MS-Off Ver
    2010, 2013
    Posts
    342

    formula to count the instances of a type of number in cells

    Hi Folks,
    I have a formula =COUNTIF(G835:I835, "<" & F835) + SUMPRODUCT(--IFERROR(SEARCH("_", G835:I835), 0)) but it does not do what I want it to do.
    Could someone look at the uploaded spreadsheet and offer a formula that works ?
    Thank you
    Doofus1


    Sorry , CORRECTION 1. Count the number of times the number in D2:F2 are below/lower than the number in C2
    2. If any of those numbers are either underlined or bold, it is to be counted twice.
    3. in D2:F2, numbers that are above the figure in C2 get a minus count of 1

    MINUS

    4 Count the number of times the number in D3:F3 are below/lower than the number in C2
    5. If any of those numbers are either underlined or bold, it is to be counted twice.
    6. in D3:F3, numbers that are above the figure in C2 get a minus count of 1


    This has to repeated for the number in C3 too

    Need help with writing a formula to achieve this
    Attached Files Attached Files
    Last edited by Doofus1; 11-23-2023 at 03:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Formula to count number of instances group of cells contain specific work
    By marcusjames in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2019, 05:43 AM
  2. Count number of instances & apply formula
    By jonhat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2018, 03:49 PM
  3. Totalling number of instances for each type
    By scorchednickel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2015, 12:42 PM
  4. [SOLVED] Require a formula to progressively count the instances and allocate a number to each
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2014, 10:45 AM
  5. [SOLVED] Formula To Count Number Of Instances
    By mamuka12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2013, 12:45 AM
  6. [SOLVED] Count number of instances of a character in a column of cells
    By mforbes6186 in forum Excel General
    Replies: 3
    Last Post: 02-09-2013, 12:12 PM
  7. Count number of cells with blue type
    By shy07014 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2009, 08:11 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