Y2allzad--I think the easiest way to do that would be to cut and paste each renter's info into another spreadsheet/part of the spreadsheet whenever they pay, that way you'll have two lists, one of not paid and one of paid. Or, you could keep your highlighted master list and copy/paste each payed tenants' info into another column--one of only those who paid. the total owed (first column) minus total paid (second column) equals how much is still owed.
This may be a stupid question, But I am having trouble figuring out how I can set up a formula on my spread sheet that will only calculate information into the formula when I have highlighted it. For example I have thirty properties that I own and I want at the end of the month to know how much the total is for the people who have payed. WHen a tenant has payed I highlight there name and rent amount in yellow. I would like my formula to only calculate the amounts that have highlighted in yellow
hello there, do you please what the equivalent of F2 and F4. Im getting crazy by starting using this Mac Excel. please help!!!tx.c.
perokiki 11 months ago
Y2allzad--I think the easiest way to do that would be to cut and paste each renter's info into another spreadsheet/part of the spreadsheet whenever they pay, that way you'll have two lists, one of not paid and one of paid. Or, you could keep your highlighted master list and copy/paste each payed tenants' info into another column--one of only those who paid. the total owed (first column) minus total paid (second column) equals how much is still owed.
See Microsoft's help site too.
springsteen8591 11 months ago
This may be a stupid question, But I am having trouble figuring out how I can set up a formula on my spread sheet that will only calculate information into the formula when I have highlighted it. For example I have thirty properties that I own and I want at the end of the month to know how much the total is for the people who have payed. WHen a tenant has payed I highlight there name and rent amount in yellow. I would like my formula to only calculate the amounts that have highlighted in yellow
Y2alizad 11 months ago
thanks so much! i hated excel, now it's sooo useful!
alx90x 1 year ago
this is wonderful millie. i had completely forgot how to do all of this!
kelsey03c 1 year ago