Results 1 to 8 of 8

SUMPRODUCT using date range

Threaded View

was SUMPRODUCT using date range 02-21-2005, 03:59 PM
AlfD Hi! I haven't actually... 02-21-2005, 08:09 PM
was Thanks for the help but it... 02-22-2005, 10:28 AM
AlfD Hi! Have a look at this... 02-22-2005, 10:46 AM
was Last question (hopefully) 02-22-2005, 11:21 AM
AlfD Hi! I reread your original... 02-22-2005, 04:57 PM
was Thank you 02-22-2005, 07:33 PM
AlfD Hi! Actually, you sorted... 02-22-2005, 08:23 PM
  1. #5
    Registered User
    Join Date
    02-21-2005
    Posts
    15

    Last question (hopefully)

    I read that posting and tried the following.

    =SUMIF(A5:A312,">="&DATE(2004,31,12),D5:D312)-SUMIF(A5:A312,">*"&DATE(2005,1,1),(D5:D312="Approved"))

    It returned 0. That is when I started playing around with SUMPRODUCT. I have been trying to figure this out for about a week. Working on it off and on durring my work day. Could you please look at the above formula? I am not very good at this and must have made a mistake. You have been very helpfull so far and I do appreciate it so much.
    Last edited by was; 02-22-2005 at 11:29 AM.

Thread Information

Users Browsing this Thread

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

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