Results 1 to 29 of 29

countif or sumproduct with 2 part formula.

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2017
    Location
    canton, ohio
    MS-Off Ver
    Office 365
    Posts
    41

    countif or sumproduct with 2 part formula.

    Ok, I know I have to be missing the simplest thing, but I have been trying to fix this since yesterday. I have googled but can not quite find where I am messing up this formula. I have attached the sheet. I am trying to count the number of late unloads, but only if they are red. Reasoning is if the truck is late the unload being late doesnt matter which is why I have it set in conditional formatting to ignore those. based on the sheet you will see some of the trucks arrive early, but can still be late unload... this is the formula I am using currently. I have edited it so many times I do not remember how I had it. But I had it working right before, just not when a truck would show up early. Any help would be great. TIA

    =SUMPRODUCT((((E2:E800-C2:C800)>0.084)*1)-(D2:D800-C2:C800>0))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNTIF embedded in a SUMPRODUCT formula
    By macrorookie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2014, 09:02 AM
  2. CountIf or SumProduct Formula Problem
    By reb2u in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2013, 06:27 PM
  3. Simple Sumproduct or Countif formula
    By gtudor in forum Excel General
    Replies: 5
    Last Post: 06-25-2012, 04:55 PM
  4. Formula Help: Countif or Sumproduct
    By 1979excelhelp in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2011, 04:02 PM
  5. problem with a countif or sumproduct formula
    By MickeyP in forum Excel General
    Replies: 1
    Last Post: 06-28-2009, 06:12 AM
  6. [SOLVED] Which formula to use? countif, sumif, sumproduct
    By zubee in forum Excel General
    Replies: 3
    Last Post: 09-02-2005, 04: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1