Results 1 to 6 of 6

Array Formula Problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    Array Formula Problem

    See the attached spreadsheet -

    This formula is in Column C - When the Order Number (Column A) is the same, column C should output the total number of jobs (Column B) for that order.
    =SUM(IFERROR((1/COUNTIFS($A$2:$A$25,$A$2:$A$25,$B$2:$B$25,$B$2:$B$25,$A$2:$A$25,$A2)),0))

    Currently, my formula is within an array formula - my sample spreadsheet is working fine, but when I use this formula in a larger spreadsheet (with approximately 4000 rows and 60 columns), this formula is grinding to a halt and and my spreadsheet isn't working any longer.

    Question - How can this formula be modified to work within my larger spreadsheet?

    Can this be done without an Array?

    Thank You
    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] Array formula problem?
    By Jowel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 05:10 PM
  2. Array Formula: my problem for some help
    By XLHead in forum Excel General
    Replies: 1
    Last Post: 10-07-2010, 03:43 AM
  3. Array / CSE formula problem
    By benclayes in forum Excel General
    Replies: 8
    Last Post: 03-06-2010, 06:12 PM
  4. Array formula problem.
    By coolhit in forum Excel General
    Replies: 4
    Last Post: 08-09-2009, 06:11 PM
  5. [SOLVED] Problem w/Array Formula
    By danw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 06:00 PM
  6. array formula problem
    By Richard Yates in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 08:05 PM
  7. Array Formula Problem
    By Taboard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-21-2005, 12:56 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