+ Reply to Thread
Results 1 to 3 of 3

Debugging help (averageifs)

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    6

    Debugging help (averageifs)

    Why is this formula wrong?


    I had an array before with the correct values, but excel would 'run out of resources'.

    Any help is appreciated!

    Cheers,
    Saul
    Last edited by Sshamash; 02-19-2013 at 09:04 AM.

  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: Debugging help (averageifs)

    Hi,

    On the face of it, nothing, but difficult to say without seeing the problem in the context of the workbook. Can you upload it?
    Given you mention running out of resources, which is another way of saying not enough RAM, try being more specific with your ranges and define ranges as say K1:K100 rather than just K:K
    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
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Debugging help (averageifs)

    Is it because you spelled Standby incorrectly?
    If not, upload an example showing your ideal result
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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