Need Formula Help ASAP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
An "If" formula may help, if you use an "x" (or something similar) instead of
a checkmark. [A1] would be the cell where the "x" would be, the formula
would go into the cell where the $ amount is needed.
eg. =if(A1="x",400,0) result: if A1 has an "x", 400 will be entered into
the cell, otherwise 0 will be entered.
 
Back
Top