+ Reply to Thread
Results 1 to 3 of 3

SUMIF Multiple Criteria or SUMPRODUCT?

  1. #1
    Registered User
    Join Date
    09-24-2008
    Location
    Arlington, VA
    Posts
    3

    SUMIF Multiple Criteria or SUMPRODUCT?

    Need a little help folks
    Have a spreadsheet, looks a little something like this:

    Column A Column B
    Award Date Task Order Value
    6/30/07 $5,156
    8/25/07 $43,149
    10/12/07 $1,324
    04/15/08 $6,993
    10/09/08 $34,344

    Government Fiscal Year begins on the first of October and ends last day of September. I’m trying to SUM Task Order Values between the dates of 10/01/2007 and 9/30/2008, essentially FY08 task order value. Getting the feeling that I cannot use the SUMIF function, though I used it to SUM FY09 task order value:

    =SUMIF(I3:I300,”>”&DATE(2008,9,30),N3:N300)

    So how about using multiple criteria to SUM FY08 data, any ideas?

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    =sumproduct((a1:a100>"10/01/2007")*(a1:a100<"09/30/2008")*b1:b100)

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284
    Quote Originally Posted by arthurbr View Post
    =sumproduct((a1:a100>"10/01/2007")*(a1:a100<"09/30/2008")*b1:b100)
    Wouldn't work in the UK, so far better to use ISO standard dates

    =SUMPRODUCT(--(A1:A100>--"2007-10-01"),--(A1:A100<--"2008-09-30"),B1:B100)

+ Reply to Thread

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