I have a rent tracking spreadsheet for my tenants. I have a column showing each month their rent due or paid. currently, this is the formula I use to pull each months rent from the list of received rents:
=SUMIFS('Rent Rec'!$C:$C,'Rent Rec'!$A:$A,'Rent Rolls'!$C4,'Rent Rec'!$B:$B,">="&'Rent Rolls'!$L$1,'Rent Rec'!$B:$B,"<"&'Rent Rolls'!$M$1)
Rent Rec Column C is the amount of rent
Rent Rec Column A is the code I use to lookup each property
Rent Roll column 4 is the code to lookup to match Rent Rec Column A
The last two are to limit the date ranges each month.
This works great unless I have a vacancy, repairs, etc. I would like to be able to put in a line of text into he Rent Rec Sheet that I use as a note showing "Moved Out", "Repairs", or whatever text I need there. Currently, my SUMIFS will only pull numbers and ignores text. Is there a way to work around this?
Thank You for the help.
=SUMIFS('Rent Rec'!$C:$C,'Rent Rec'!$A:$A,'Rent Rolls'!$C4,'Rent Rec'!$B:$B,">="&'Rent Rolls'!$L$1,'Rent Rec'!$B:$B,"<"&'Rent Rolls'!$M$1)
Rent Rec Column C is the amount of rent
Rent Rec Column A is the code I use to lookup each property
Rent Roll column 4 is the code to lookup to match Rent Rec Column A
The last two are to limit the date ranges each month.
This works great unless I have a vacancy, repairs, etc. I would like to be able to put in a line of text into he Rent Rec Sheet that I use as a note showing "Moved Out", "Repairs", or whatever text I need there. Currently, my SUMIFS will only pull numbers and ignores text. Is there a way to work around this?
Thank You for the help.
