Results 1 to 3 of 3

Probably a simple error with my SUMPRODUCT formula (returning VALUE) but I'm stuck!

Threaded View

Duncasaur Probably a simple error with... 07-06-2015, 10:44 AM
Kaper Re: Probably a simple error... 07-06-2015, 10:53 AM
Duncasaur Re: Probably a simple error... 07-06-2015, 10:58 AM
  1. 07-06-2015, 10:44 AM #1
    Duncasaur is offline
    Registered User
    Join Date
    03-26-2014
    Location
    UK
    MS-Off Ver
    Google Sheets (post December 2013)
    Posts
    2

    Probably a simple error with my SUMPRODUCT formula (returning VALUE) but I'm stuck!

    I'm trying to SUM total sales on a week by week basis for a range of products.
    I have a formula I use in a different workbook and it works fine, I've tried adapting it and I cannot for the life of me figure out why it's returning #VALUE! .

    Untitled.png
    Attached Files Attached Files
    Last edited by Duncasaur; 07-06-2015 at 10:59 AM.
    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. Sumproduct formula returning #Value! error
    By brizmol1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2014, 05:16 PM
  2. Simple VBA returning syntax error
    By BearLovesLuna in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2013, 05:09 PM
  3. [SOLVED] SUMPRODUCT formula returning #NUM! error message
    By inneedofhelp1 in forum Excel General
    Replies: 5
    Last Post: 11-06-2012, 10:04 AM
  4. [SOLVED] Sumproduct formula is returning #value error
    By ensmith in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 09:56 PM
  5. [SOLVED] SUMPRODUCT formula returning #VALUE! error
    By Valerie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2006, 09:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1