Results 1 to 9 of 9

Sumproduct that filters out errors vlaues

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Question Sumproduct that filters out errors vlaues

    I know how to create sumproduct formulas that have conditions (see below). But is there a way to create a sumproduct formula that only sums values that aren't errors?

    Here is my formula that accounts for 2 filters ("Americas" and D$6):
    Formula: copy to clipboard
    =SUMPRODUCT(--('5-8-13'!$E$2:$E$5000="Americas")*('5-8-13'!$H$2:$H$5000=Americas!D$6),'5-8-13'!$T$2:$T$5000)


    My data includes "#DIV/0!" errors in column T:T and I want to avoid those rows. Please tell me if I need to clarify.

    Thanks
    Last edited by Craig K.; 05-21-2013 at 03:52 PM. Reason: resolved the issue that necessitated the thread

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