+ Reply to Thread
Results 1 to 1 of 1

#N/A in sumproduct

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2010
    Posts
    44

    #N/A in sumproduct

    hi all,

    need some help here, this is my formula for sumproduct,

    SUMPRODUCT(--('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$B$2:$B$65005=$A$7)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$G$2:$G$65005=$AA$10)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$L$2:$L$65005=$A11)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$M$2:$M$65005))

    For my jan to july file the above formula is doing well, but after updating my file "all outlets jan-dec 2015" for august data, i got all results to #N/A,
    even my jan to july files was broken,

    could you help me figure out what happen or have i done something wrong my file or my formula?

    pls see attached file for clearer view.

    thank you.
    Attached Files Attached Files
    blessed are those who share whats theirs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Use sumproduct to further parse a sumproduct calculation
    By Araise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2015, 08:17 PM
  2. Count SUMPRODUCT Members / Average of SUMPRODUCT
    By Shingaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 03:59 PM
  3. Replies: 1
    Last Post: 05-19-2012, 02:54 AM
  4. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  5. Replies: 6
    Last Post: 03-09-2011, 08:01 AM
  6. Subtract Sumproduct from a sumproduct
    By Prcntrygrl in forum Excel General
    Replies: 6
    Last Post: 01-17-2011, 02:34 PM
  7. Using a SumProduct Count to find a SumProduct Total?
    By XL021710 in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 08:31 AM

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