Results 1 to 4 of 4

sumproduct for two ranges

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    46

    sumproduct for two ranges

    Hi, I hope someone can help me here.

    I'm using 2003 and I am trying to use sumproduct for the following but having no luck.

    I have a list of dates (C2:C31) running from 01/02/2014 to 02/03/2014.

    I have a list of varying ages (D2:D31)

    K11:K15 has age ranges, e.g. 18-25.

    I need to take a date range of 01/02/2014-28/02/2014 then count how many occurrences of 18-25 there are in that given date range (the formula being in L11)

    I can sumproduct a date range but I cannot lend it to an age range if you will.

    I've posted a dummy book if someone could have a look.

    I hope someone can help, googling and cobbling together formulas has not helped my cause!

    Thanks
    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. Help with SUMProduct with two date ranges
    By Muttstaz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2011, 04:03 PM
  2. Sumproduct with different ranges
    By Kenny J in forum Excel General
    Replies: 7
    Last Post: 11-09-2008, 10:46 PM
  3. SUMPRODUCT and named ranges
    By clayton in forum Excel General
    Replies: 3
    Last Post: 11-02-2006, 09:08 PM
  4. sumproduct between 2 ranges
    By Patty via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 07-14-2005, 04:05 PM
  5. PRoblem with Ranges and Sumproduct under VBA
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2005, 01:06 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