Results 1 to 17 of 17

Why sumproduct formula return result 0

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Kosova
    MS-Off Ver
    Excel 2007
    Posts
    6

    Why sumproduct formula return result 0

    HI..IM NEW IN THIS FORUM AND IN EXCEL GENERALY

    I have a little problem with sumproduct formula in excel 2007...
    =SUMPRODUCT(F4:F35=B82,G4:G35=F98,J4:J35) and i get the 0 result

    but when i put manualy this formula i get the proper result
    =SUMPRODUCT((F4:F35=B82)*(G4:G35=F98)*(J4:J35))

    my colums are TEXT ---TEXT---NUMBER

    so is there a way not to do this manualy ?!

    THNX
    Last edited by zbor; 05-18-2012 at 04:01 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