Forum Discussion
Problem with a formula
I have a spreadsheet in which I post rent amounts for each month. the spread sheet consists of 12 windows, one for each month, A base sheet which contains names and amounts and a record sheet with a...
In general terms, there are two approaches to such a problem. One, more typical of database applications is to sum everything but to use SUMIFS which allows the criterion fields to determine whether to include each particular value in the total.
The other, more array oriented, is to identify the values to be summed as a contiguous range of cells (might involve searching for the first and last occurrence of "January" using XLOOKUP, for example) and apply the SUM function to the restricted range. We would need more information to determine which will serve your needs the better.
- Thank you for your reply.
The program has 40+ rental units, which I have on one section of the document. On the second section is the tenant payment information. the next 12 sections are monthly reports for each tenant showing payment dates, past due amounts if any and any comments needed for each tenant. My customer wants a report each month showing how much was paid and how much each tenant is behind in payment. As it is currently set up, the payments for January will add the monthly amount due for February, March and April. This does not look good if I have to go back and reprint these reports for whatever reason.
The program has 40+ rental units, which I have on one section of the document. On the second section is the tenant payment information. the next 12 sections are monthly reports for each tenant showing payment dates, past due amounts if any and any comments needed for each tenant. My customer wants a report each month showing how much was paid and how much each tenant is behind in payment. As it is currently set up, the payments for January will add the monthly amount due for February, March and April. This does not look good if I have to go back and reprint these reports for whatever reason.
