Calculation Issues

How to Calculate Positive Year-to-Date (YTD) Income in Excel

Rana Garcia Sep 30, 2026 869 views

Question details

The user wants to calculate the total positive income from the beginning of the current year up to today, excluding any negative values from a mixed income/expense column.

How to Calculate Positive Year-to-Date Income in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking ongoing financial records where dates are in one column and a mix of positive income and negative expenses are in another column, requiring a dynamic running total for the current year.
Observed behavior: A specific multi-criteria formula is required to dynamically filter rows by the current year, today's date, and amounts greater than zero.

Before you start

Ensure that the dates in your date column are formatted as actual Excel dates rather than text, otherwise the date-based formula criteria will fail to calculate correctly.

Solution 1Recommended

Use the SUMIFS Function to Calculate YTD Positive Income

Apply a multi-criteria SUMIFS formula to dynamically filter dates from January 1st to today, capturing only values greater than zero.

The SUMIFS function allows you to add values based on multiple conditions. By combining it with the TODAY, YEAR, and DATE functions, your calculation will automatically update as days pass and years change.

Select the target cell

Click on the cell in Column E (or your desired location) where you want the Year-to-Date income to be displayed.

Enter the SUMIFS formula

Type the formula: =SUMIFS(C:C,A:A,">="&DATE(YEAR(TODAY()),1,1),A:A,"<="&TODAY(),C:C,">0")

Execute the calculation

Press Enter. The formula will automatically check Column A for dates on or after January 1st of the current year, and on or before today's date, summing only the positive numbers in Column C.

Use the SUMIFS Function to Calculate YTD Positive Income

Dynamic Updating: Because this formula relies on the TODAY() function, your YTD income will update automatically every time you open the workbook or enter new data.

Solution 2

Use AutoFilter and SUBTOTAL for Manual Verification

If you prefer a visual approach without combining complex functions, you can filter the data and use the SUBTOTAL function.

Powerful Spreadsheet Tool

Calculate Financial Formulas Easily with WPS Office

WPS Spreadsheets provides full support for advanced functions like SUMIFS, TODAY, and DATE. You can manage your financial tracking seamlessly with exactly the same formulas used in Microsoft Excel.

1. Open your financial spreadsheet: Launch WPS Office and open your .xlsx financial tracking file.
2. Select your calculation cell: Click on the cell where you wish to display the Year-to-Date income.
3. Input the dynamic formula: Paste the =SUMIFS formula with the specific conditions as provided above.
4. Get instant results: Press Enter to instantly calculate your real-time YTD positive income.

100% compatible with Microsoft Excel formulas and .xlsx file formats.Lightweight software optimized for quickly processing large financial datasets.Intuitive UI that requires no learning curve for Excel users.Free to download with comprehensive calculation capabilities built-in.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SUMIFS formula returning zero for the YTD income?

This commonly happens if the dates in your date column (Column A) are formatted as text instead of recognizable date values. It can also occur if the criteria syntax, such as ">="&DATE(...), is missing quotation marks or the ampersand symbol.

How do I calculate YTD expenses instead of positive income?

To calculate expenses (assuming they are entered in the column as negative numbers), simply change the final criteria in your SUMIFS formula from ">0" to "<0".

Can I set a specific fiscal year start date rather than January 1st?

Yes. Instead of using DATE(YEAR(TODAY()), 1, 1), you can adjust the month and day arguments. For instance, if your fiscal year starts on July 1st, replace the criteria with DATE(YEAR(TODAY()), 7, 1). If today's month is before July, you will need to add an IF statement to subtract a year from YEAR(TODAY()).

Excel & Data Problems