Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • How to use Excel ROW Function
  • How to use Excel MMULT Function
  • How to get last row in mixed data with blanks in Excel
  • Excel Advanced Lookup using Index and Match Functions

Data Analysis Examples

  • Excel Pie Chart
  • Add Outline to Data in Excel
  • Randomize/ Shuffle List in Excel
  • Remove Duplicates Example in Excel
  • Managing Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation require unique number
  • Excel Data validation must begin with
  • Excel Data validation allow uppercase only
  • Excel Data validation don’t exceed total
  • Excel Data validation number multiple 100

Sum if date is greater than in Excel

by

This tutorial shows how to Sum if date is greater than in Excel using the example below;

Formula

=SUMIF(range,">"&DATE(year,month,day),sum_range)

Explanation

To sum if based on dates greater than a certain date, you can use the SUMIF function.

In the example shown, cell H5 contains this formula:

=SUMIF(date,">"&DATE(2015,10,1),amount)

This formula sums the amounts in column D when a date in column C is greater than Oct 1, 2015.

Worked Example:   Sum if ends with in Excel

How the formula works

The SUMIF function supports Excel’s logical operators (i.e. “=”,”>”,”>=”, etc.), so you can use thee as you like in your criteria.

In this case, we want to match dates greater than Oct 1, 2015, so we are using the greater than (>) operator with the DATE function to create a date:

">"&DATE(2015,10,1)

The DATE function is a safe way to create dates for function criteria, because it eliminates problems associated with regional date settings.

Worked Example:   Sum if date is between in Excel

Note that we need to enclose the greater than operator in double quotes and join it to the date with an ampersand (&).

Date as cell reference

If you want to expose the date on the worksheet so that it can be easily changed, use this formula:

=SUMIF(date,">"&A1,amount)

Where A1 is a reference to a cell that contains a valid date.

Worked Example:   SUMIFS multiple criteria lookup in table in Excel

Alternative with SUMIFS

You can also use the SUMIFS function. SUMIFS can handle multiple criteria, and the order of the arguments is different from SUMIF. The equivalent SUMIFS formula is:

=SUMIFS(amount, date,">"&DATE(2015,10,1))

Notice that the sum range always comes first in the SUMIFS function.

Post navigation

Previous Post:

Sum if equal to one of many things in Excel

Next Post:

Sum if date is between in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Split numbers from units of measure in Excel
  • Two ways to Compare Text in Excel
  • SUBSTITUTE function vs REPLACE function in Excel
  • How to compare two text strings in Excel
  • How to display conditional message with REPT function in Excel
  • Get work hours between dates and times in Excel
  • Add workdays no weekends in Excel
  • Count birthdays by month in Excel
  • Get first day of previous month in Excel
  • How to calculate quarter from date in Excel
  • Calculate interest rate for loan in Excel
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • DB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles