Results 1 to 9 of 9

Iserror works on one column but not two in small nested formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Iserror works on one column but not two in small nested formula

    Hello People..
    I'm trying to get Iserror to ignore #N/A errors from a chart data area. I'm wanting to count the number of times in a row something happens, that bit I can do. I'm trying to get Iserror to ignore the errors in columns KE6:KE51 & KF6:KF51. I can only get it to ignore one column or the other, not both at the same time. I need to combine the occurrences of "1" in both columns & have them appear in column KB if they are in the other columns. If not leave the cell blank. I'm having to do this as counting a run of entries doesn't work with errors in the column. Hoping this explanation is clear enough
    I've attached an example
    Any ideas please.
    Thanks
    Attached Files Attached Files

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