To use SUMIF to sum values based on date as criteria, you can refer to the cell where you have the date, or you can input the date inside the function directly. In SUMIFS, you have the criteria argument and in this argument; you need to specify the date for which you want to sum values.
In this tutorial, we will learn to use Excel’s SUMIF function on a date.
Use SUMIF by Date in Excel
- First, enter
=SUMIF(in the cell where you want the sum.
- After that, refer to the date column, range A2:A15.
- Next, in the criteria argument, refer to the cell where you have the date.
- Now, in the last argument, refer to the sum column, range B2:B15.
- In the end, enter the closing parentheses and hit enter to get the result.
With the formula above, you get the sum for the date “15-Oct-2022” in the result.
You can also enter the date within the function argument as a value.
=SUMIF(A2:A15,"15-Oct-2022",B2:B15) =SUMIF(A2:A15,DATE(2022,10,15),B2:B15) =SUMIF(A2:A15,"15-10-2022",B2:B15)
SUM Before or After a Date using SUMIF
You can also use a logical operator with the date to sum before or after a specific date. In the following example, we have a greater than sign with the date.
When you hit enter, it returns, 2028, which is the total of the date 15-Nov-2022.
In the same way, you can use a lower than (<) operator to sum based on dates lower than the date in cell D4.
Here are some other operators that you can use:
- Not equal to <>
- Greater than or equal to >=
- Lower than and equal to <=