Marc:

The YTD surplus/Loss is simply the current balance for all account that make up your income statement.

In column B include the entire range, such as 4000:9999

In which ever column you have your amounts in use the same formula to return the balance.