Results 1 to 3 of 3

Count(filter) formula does not yield correct values

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2020
    Location
    Australia
    MS-Off Ver
    MS OFFICE 365
    Posts
    23

    Count(filter) formula does not yield correct values

    Hi,
    I have a register with count(filter) formula to calculate the number of filtered rows in another sheet. However, the formula didnot yield the correct results. As, for example in the sheet attached, the yellow highlighted number in the first sheet should be 52 and not 49, and I could not figure out where the error is in the formula. The formula is as below:

    =COUNT(FILTER('ITP Reg'!$A$5:$L$494,('ITP Reg'!$G$5:$G$494='ITP Summary by package'!$A60),"No results"))
    The sheet is attached.

    I would really appreciate some help on this, thanks.

    Sud
    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. Replies: 6
    Last Post: 07-24-2020, 08:09 AM
  2. SUMIF that will yield negative values, but not positive values.
    By chkn89 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 02-18-2020, 03:09 AM
  3. [SOLVED] Index/Aggregate formula calculates correct row but does not yield name from Index array
    By FivestarMac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2019, 05:07 PM
  4. Formula to yield correct results
    By ben_hensel in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-10-2016, 04:07 PM
  5. [SOLVED] Filter and count unique values in a single formula
    By gruzlor in forum Excel General
    Replies: 8
    Last Post: 03-21-2014, 09:14 AM
  6. Replies: 1
    Last Post: 01-14-2013, 04:01 AM
  7. Bond Yield to Maturity using the Yield function in Excel
    By rahulk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2009, 03:32 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