Results 1 to 6 of 6

First row of array formula not working?

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    80

    First row of array formula not working?

    Can someone help me quickly? I'm sure this is really simple but I just can't figure it out.

    On the SOLD worksheet, for some reason row 3 isn't populating for the 4wk and 3 mo ave and totals (F3-I3), even though the values it is supposed to draw from are populating in columns N through AC.

    It has the array brackets and I compared them with the row below and don't see any differences. The formatting is the same. I'm at a loss. I also added in a new person (line 7). He doesn't have enough data for an average but I thought it would show a total for him.

    Thanks in advance! This forum has been a godsend.
    Amy
    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 Not Working - Help
    By GemBox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2017, 07:30 AM
  2. [SOLVED] Array Formula Not Working....
    By sagar007 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2012, 01:16 AM
  3. Array formula not working
    By MIAO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2012, 10:01 AM
  4. Array formula not working
    By Theodjinn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 04:09 AM
  5. Array Formula not working
    By TheCherub in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2008, 08:17 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