Results 1 to 5 of 5

How to apply ISERROR in an Array Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    How to apply ISERROR in an Array Formula

    Attached is a simple example of what I’m trying to achieve. There are differing money amounts in column C and the month those amounts are due to be paid in column B. Column E contains an array formula based upon a lookup value in cell G3 (month due for payment). The formula works fine but of course will report #NUM errors when it runs out of values to find from G3. In this example, I wanted J3 to return the total amount due in Jan but of course it also returns a #NUM error as it references the total error in E18. I have tried ISERROR but cannot get it to work – am I on the right track or is there a simpler alternative?
    Attached Files Attached Files
    Last edited by kborgers; 01-13-2012 at 02:35 PM.

Thread Information

Users Browsing this Thread

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

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