Here, we will guide you to know the simple formula used to sum the values, if the date is greater than a certain date in Excel Office 365. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To sum the values greater than a certain date in Excel, use the below formula.
=SUMIF(range,”>”&DATE(year,month,day),sum_range)
Syntax Explanations:
- SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
- DATE – In Excel, this function will combine three different values and returns them as a date. Read more on the DATE Function.
- Sum_Range – It represents the input values given in the worksheet.
- Comma symbol (,) – It is a separator which helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Range – It represents the input values given in the worksheet.
Example:
- Let’s consider the below image to sum the values greater than a certain date.
- Refer to the below image.
- Here, we will give the input values in Column B and Column C.
- Then, enter the given formula in the selected area.
- Finally, we will get the result in Cell F3.
Verdict:
In this tutorial, you can get to know the simple formula used to sum the values, if the date is greater than a certain date in Excel Office 365. Hope that this article is useful to you. If you have any doubts/queries, don’t forget to share it with us. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)