Use TODAY in Excel SUMIFS to Total the Current Month
Question details
Calculate a current-month total using TODAY while excluding rows marked Yes.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sum values in I7:I28 when their dates in A7:A28 fall in the current month and their markers in M7:M28 are not Yes.
- Observed behavior
- The desired total should update for the current month and omit rows marked Yes.
Check that A7:A28 contains valid Excel dates, I7:I28 contains the amounts to sum, and M7:M28 contains the exclusion markers. Choose an unused cell, such as K1, to hold TODAY(), and adjust the ranges and cell reference if your layout differs.
Use SUMIFS with current-month date boundaries
Use this formula to sum the current month and exclude Yes markers, even when dates include times.
Select the unused cell K1, enter =TODAY(), and press Enter.
Select an empty result cell and enter =SUMIFS(I7:I28,M7:M28,"<>Yes",A7:A28,">="&EOMONTH($K$1,-1)+1,A7:A28,"<"&EOMONTH($K$1,0)+1).
Press Enter and compare the result with the current-month rows in columns A, I, and M. Change all ranges together if your data occupies different rows.

Use SUMPRODUCT with current-month date boundaries
Use SUMPRODUCT as an alternative when you prefer to combine the conditions in a single calculation.
Calculate Current-Month Totals in WPS Spreadsheet
Use TODAY, EOMONTH, and SUMIFS in WPS Spreadsheet to total current-month values while excluding rows marked Yes.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
- 2. Enter the reference date: Select an unused cell such as K1, enter =TODAY(), and press Enter.
- 3. Calculate the total: Select an empty result cell and enter =SUMIFS(I7:I28,M7:M28,"<>Yes",A7:A28,">="&EOMONTH($K$1,-1)+1,A7:A28,"<"&EOMONTH($K$1,0)+1). Press Enter.
- 4. Save the workbook: Check the result, then select File > Save or Save As to save the workbook.

Frequently Asked Questions
Will the formula include dates with times on the last day of the month?
Yes. The upper condition uses <EOMONTH($K$1,0)+1, so it includes all times on the last day but excludes the first day of the next month.
Does the formula exclude both Yes and yes?
Yes. The SUMIFS criterion "<>Yes" is not case-sensitive, so it excludes both Yes and yes. Blank markers are included.
Why put TODAY() in a separate cell?
Entering =TODAY() in K1 and referencing $K$1 gives both date boundaries the same reference date, avoiding a theoretical mismatch if calculation occurs around midnight.
Why might a current-month row be missing from the total?
Check that its column A value is a real spreadsheet date rather than text, its column I value is numeric, and its column M marker is not Yes. Also verify that all formula ranges cover the row.




