Results 1 to 5 of 5

Confused, SUMPRODUCT or SUMIFS to compare 2 dates in a row

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    59

    Confused, SUMPRODUCT or SUMIFS to compare 2 dates in a row

    Hi

    I am unsure of the crrect way to go about this task.

    I have these columns in my Excel table

    COL A: An £amount, (which represents is an upcoming bill payment)
    COL B: the due date for the bill
    COL C: A date set by the user to be reminded of the forthcoming payment

    I am trying to write a formula that will SUM all forthcoming payments that are after the reminder dates set by the user in COL B. This formula will naturally be outside the table itself.

    As the title declares I'm confused about whether this needs to be an array formula say with SUMPRODUCT or if it can be achieved with a SUMIFS in EXCEL 2007

    Many thanks all
    Last edited by coasterman; 09-29-2013 at 03:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-03-2012, 10:32 PM
  2. [SOLVED] Macro executes but not giving results :confused::confused::confused:
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 10:49 AM
  3. Replies: 34
    Last Post: 05-23-2012, 04:08 PM
  4. Confused.com... Sumproduct or Sumif???
    By Ho-hum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2011, 05:31 PM
  5. DAYS360, dates - very confused
    By happyaslarry in forum Excel General
    Replies: 2
    Last Post: 01-18-2005, 07:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1