Calculations Based on Highlighted Cells Possible?

Hi;

I have two rental properties that are managed by a Realty company. I use an excel spread sheet for rents received and expenses. The sheet starts on the first of January and ends on the 31 of Dec for each year.

Usually I take each line from my Management Company's Statement and enter it into excel. The problem I have is the math of the Management Company is not always right. The calculations I am looking for would only be based on the current month I am working with. In Jan I might have 5 line entries, and in Feb I could have 15 (Based on expenses).

So what I would like to do is highlight the lines for the month and have excel tell me the income received, minus my expenses and distributions and tell me my balance. This way I could look at the balance on my statement and see right away if there is a problem.

Is this possible?

Thanks
Pat

Without seeing the spreadsheet you are using, I would say to create 12 different areas on the spreadsheet, 1 for each month.

I always find it easier to separate what you want excel to do into it's simplest functions, then recombine it in the back end for your more sophisticated approaches.

If you post the excel file, I might be able to offer a more specific suggestion.