Results 1 to 28 of 28

COUNTIF/SUMPRODUCT(?) to create a matrix from data

Threaded View

  1. #26
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: COUNTIF/SUMPRODUCT(?) to create a matrix from data

    Grrr.

    Normally, I overcomplicate things. This time, I undercomplicated the problem. Once I saw what was causing the problem, it was easy enough to fix. (I was not checking that the vehicle departing was the same as the one that arrived - if vehicle A arrived at 0700, and left at 0800, it was counted. If another subsequently arrived and left at 1100, I had not checked that it was the same vehicle that had arrived at 0700). I deleted two of the Named ranges, as they are notrequired. So, with a red face, I have now cross-checked my formula as well as I can. I am now confident that we're there. It might be an idea to keep the cross-checking formulae as an ongoing QA measure.
    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] Sumproduct multiple criteria query
    By Millixcel in forum Excel General
    Replies: 3
    Last Post: 05-03-2018, 07:24 AM
  2. Create a new table (or matrix) from an exported set of data from a website.
    By dherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 11:19 AM
  3. Replies: 6
    Last Post: 11-18-2013, 11:28 PM
  4. Trying to create an output grid/matrix with custom data.
    By JoeTheBro in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 10:47 AM
  5. Replies: 3
    Last Post: 10-18-2010, 11:09 AM
  6. Create a matrix from data in three column
    By sa02000 in forum Excel General
    Replies: 3
    Last Post: 06-27-2006, 09:30 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