+ Reply to Thread
Results 1 to 5 of 5

Countif issue

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Countif issue

    Kidush Hachodesh.xlsx
    Im trying to do a count the items in C12thru30 that match criteria but only look at rows <= another criteria
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Countif issue

    I don't understand your data. Please manually add the results you expect, tell us which cells are the results and explain the calculation you used to derive the results.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Re: Countif issue

    Kidush Hachodesh.xlsx
    I have a table in B12:C30. In K13 and down I have the results. Im counting the number of "Pshuta"s I have in
    the table including only rows <= the value in column G of the result's row.
    I hopw this clearer.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Countif issue

    I don't understand your results

    Why does Pshuta in K13 show 1 when there are two values <=0, i.e. G12 & G24
    Similarly
    Why does Ibur in K14 show 7 when tthere are 6 values <=10, i.e. G14, G17, G19, G25, G28, G30

  5. #5
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Re: Countif issue

    K13 shows 1 because in array B12:C30, including rows until the value of G13 (which is 0) there's one instance of Pshuta.
    Im taking the value of a row in G, looking it up in B12:C30, and returning all "Pshuta"s in those Cs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIF Issue
    By [email protected] in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2016, 04:13 AM
  2. Could someone please help with this CountIF issue
    By Lacer75 in forum Excel General
    Replies: 6
    Last Post: 12-09-2014, 05:31 PM
  3. [SOLVED] countif issue
    By atom715 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2014, 02:26 AM
  4. Countif Issue
    By coolhit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2013, 08:52 PM
  5. COUNTIF issue
    By JO505 in forum Excel General
    Replies: 4
    Last Post: 05-29-2011, 09:13 PM
  6. CountIF issue
    By edmdas in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2007, 11:48 AM
  7. [SOLVED] issue with countif in vba
    By Xavier Minet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2005, 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