Results 1 to 6 of 6

Sumproduct error with weekday and blank cells

Threaded View

  1. 08-19-2015, 01:19 AM #5
    ledpham
    ledpham is offline
    Registered User
    Join Date
    01-31-2012
    Location
    Saigon, Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Sumproduct error with weekday and blank cells

    Thank you, I just found that this one worked as well

    =SUMPRODUCT(--($C$6:$R$6=1)--($C$6:$R$6=7),$C7:$R7)
    Last edited by ledpham; 08-19-2015 at 01:22 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. [SOLVED] SumProduct and Weekday problem
    By dubcap01 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-04-2014, 11:44 PM
  2. #VALUE! error in SUMPRODUCT with DATEVALUE formula, when there are blank lines in the data
    By london17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-31-2013, 09:18 PM
  3. [SOLVED] SUMPRODUCT Problem with blank non blank cells included in range and ever changing range
    By argegg26 in forum Excel General
    Replies: 15
    Last Post: 04-25-2012, 05:21 PM
  4. Sumproduct using blank cells
    By Wskip49 in forum Excel General
    Replies: 4
    Last Post: 12-18-2008, 03:52 PM
  5. Difficult formula SUMPRODUCT,MATCH,WEEKDAY
    By edwardpestian in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2006, 06:53 AM
  6. [SOLVED] sumproduct with 0/blank cells
    By Matt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2005, 06:30 PM
  7. [SOLVED] SUMPRODUCT - Blank Cells
    By Peggy Sue in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 06:17 PM

Tags for this Thread

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