Results 1 to 5 of 5

Adding =countif to an =sumproduct range (Maybe)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-17-2008
    Location
    Vernon, CT
    Posts
    132

    Question Adding =countif to an =sumproduct range (Maybe)

    I am having an issue with my formula. =SUMPRODUCT((A2:A2000=D3)*(B2:B2000)) The formula works great except I need to add countif greater than 0 to this and I can't figure out how. The issue is (Attached), that in cell D3 if you have nothing entered (This is what the user would search by), it (E3) will count every customer with a 0 ship to in column A. I want to ignore those. Also, the info that is in columns A & B will be added from another program (iSeries navigator). These numbers are not manually entered. Only D3 would be for the user.

    Thanks for any help,

    Jay
    Attached Files Attached Files
    Last edited by jayclinton; 10-19-2011 at 08:45 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