+ Reply to Thread
Results 1 to 2 of 2

Sum array excluding #N/A

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    31

    Sum array excluding #N/A

    Hi all,

    I'm having issues getting an array to work that also excludes #N/A's.

    Below is what I have attempted but neither have worked.
    5:5 - Dates
    6:6 - Numbers
    D61 - Date of current month.

    Attempt 1 - {=SUM(IF(AND(MONTH($5:$5)=MONTH(D$61),$6:$6<>#N/A),$6:$6))}
    Attempt 2 - {=SUM(IF(IFERROR(MONTH(5:5)=MONTH(D$61),0),6:6))}

    Thanks in advance for your help.
    Last edited by BC TIPPING; 10-09-2017 at 12:39 AM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,923

    Re: Sum array excluding #N/A

    Try:

    =SUM(IF(MONTH($5:$5)=MONTH(D$61),IF(ISNUMBER($6:$6),$6:$6)))
    Last edited by Phuocam; 10-09-2017 at 12:31 AM.

+ 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. [SOLVED] Find max/min in an array excluding columns
    By rpcoates1956 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-04-2016, 02:01 PM
  2. Excluding data pulled by using an array
    By aRabidLunatic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2014, 11:19 PM
  3. Excluding Cells From an Array!
    By AstToTheRegionalMGR in forum Excel General
    Replies: 6
    Last Post: 12-15-2014, 04:13 PM
  4. [SOLVED] excluding a part of an array formula
    By twiggywales in forum Excel General
    Replies: 2
    Last Post: 05-25-2012, 11:02 AM
  5. Frequency Array Excluding Zeros
    By basalganglia in forum Excel General
    Replies: 7
    Last Post: 11-20-2011, 04:28 PM
  6. Array average excluding zeros
    By ChrisNor in forum Excel General
    Replies: 5
    Last Post: 12-06-2010, 08:55 AM
  7. Sumproduct excluding an Array
    By Odysseus in forum Excel General
    Replies: 4
    Last Post: 12-16-2009, 12:42 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