Calculation Issues

Use TODAY in Excel SUMIFS to Total the Current Month

Bushra ParveenBushra Parveen Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Use SUMIFS with current-month date boundaries

Use this formula to sum the current month and exclude Yes markers, even when dates include times.

1
Enter today's date

Select the unused cell K1, enter =TODAY(), and press Enter.

2
Enter the SUMIFS formula

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).

3
Check the total

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 SUMIFS with current-month date boundaries
How the date limits work: The formula includes dates from the first day of the current month up to, but not including, the first day of the next month. This also includes times on the last day. Blank markers are included because they are not Yes.
Calculate in WPS Spreadsheet

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. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
  2. 2. Enter the reference date: Select an unused cell such as K1, enter =TODAY(), and press Enter.
  3. 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. 4. Save the workbook: Check the result, then select File > Save or Save As to save the workbook.
Automatically calculate the current month's totalExclude marked rows with a SUMIFS criterionOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and cell references
microsoft office alternative - wps office

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.