Need Formula Help ASAP

R

Red

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
 
K

KRSOUCIE

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top