Results 1 to 15 of 15

Conditional SUM Formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Conditional SUM Formulas

    Can we write the formula on the cell A27 with "SUMIFS" function?


    On SUMIFS explanation it says it requires several conditions. But on syntax it says

    Criteria, Criteria Range1, Criteria

    so i think writing the formula like this but it won't work.
    Formula: copy to clipboard

    =SUMIFS(Amount, DueDate, DueDate>DATE(2010, 5, 1)
    Attached Files Attached Files
    Last edited by zanshin777; 01-03-2016 at 11:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formulas that can be used in conditional formatting
    By Linda-Decypher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 03:22 PM
  2. Conditional Formulas?
    By lanespoli in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-21-2014, 10:28 PM
  3. [SOLVED] Conditional Formulas
    By spursrule68 in forum Excel General
    Replies: 4
    Last Post: 11-06-2012, 05:13 PM
  4. Excel 2007 : Conditional Formulas - HELP!
    By willroney in forum Excel General
    Replies: 2
    Last Post: 10-06-2010, 09:44 AM
  5. Conditional formulas help
    By J. Moore in forum Excel General
    Replies: 4
    Last Post: 07-21-2009, 04:47 PM
  6. Conditional Formulas
    By haxmania1 in forum Excel General
    Replies: 15
    Last Post: 11-17-2008, 02:52 AM
  7. conditional formulas
    By luna55 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2008, 04:16 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