Results 1 to 8 of 8

Sumproduct Error

Threaded View

  1. 06-23-2015, 08:32 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Sumproduct Error

    I have had to amend my model slightly and now my sumproduct formula isn’t working.

    In cell C10 of the sheet “FDQM Load 11” it should be picking up the value of £500 from cell R10 of the sheet “P&L Walk”

    Why isn’t it working?

    Is there a work around as i can not change the format?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct #N/A error
    By Blake 7 in forum Excel General
    Replies: 12
    Last Post: 11-12-2014, 11:12 PM
  2. sumproduct error
    By krunk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2013, 02:13 PM
  3. SUMPRODUCT Error
    By babuda in forum Excel General
    Replies: 6
    Last Post: 05-04-2009, 02:54 PM
  4. Sumproduct and value error
    By bountifulgrace in forum Excel General
    Replies: 2
    Last Post: 10-26-2006, 07:33 AM
  5. Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1