I desparately need to know if a formula can be created for my spreadsheet. I
have a cell I just need to click and a check mark appear, but in another
cell, in another sheet in the same spreadsheet I need a dollar amount to
appear. Example: I collect money for rent for different buildings. Each
building has its own worsheet in the spreadsheet. Then I have a summary
spreadsheet that has all the deals I want to get a yearly total for. One
building I receive $400 a month. Its will be the same every month so I just
want to put a check mark each month to know it was received. However, I want
a formula that says once a check mark appears in individual building cell
sheet, the 400.00 will appear and total itself for the whole year on the
summary sheet tab. I know this sound confusing, but I did not know if it was
possible? Need to know ASAP.. Thanks RED