First time forum user

[Ken L.]

Hello,
I am just a beginner with excel 2007

I am trying to build a simple spreadsheet to pay my 6 year old daughter allowance and teach her about math.

My problem is I cannot figure out how to add currency in the cell with text and then have the totals added up at the bottom of the page.

I would like to add currency figure on each chore on the second page and then when I use the drop down list on the first page it will say (make bed $.50) and at the end of each day add up the totals for all the cells under chores completed and then at the end of the week add up all the days for her grand total allowance.

I hopefully will come up with a nice spreadsheet that will also teach my children about work, since I have a 15 month old son I will get good usage out of this spread sheet.

I can
e-mail the spreadsheet if anybody needs to see it to help me out.


Thank you,

[martindwilson]

just zip the workbook and post it here for us to look at!

[mikerickson]

Ken,

Welcome to the forum.

Please read the link in my signature about cross posting. It explains why the forum rules require that you post a link to your cross-posts.
http://www.mrexcel.com/forum/showthread.php?t=310169

Mixing kinds of data together makes spreasheets harder to work with. You might want to have "Make bed" and 50¢ in differerent cells. A task column matched with a money column. If you want them to be combined in the drop-down, a helper column would be used.

As martinwilson said, posting your current workbook would be the best way to get suggestions and help.

Welcome.

[jujuwillis]

Hello Ken

I have attached a simple chore sheet

There is an explanation on this chore sheet as to how the sheet works.

Hope this was something along the lines that you were looking for.

Good luck with teaching your daughter with her math.

[Ken L.]

Hello,

I wanted to apologize. I was not aware that cross posting was not proper.
I figured if i put it in two places I would get this frustrating problem solved.

I will post my spread sheet after i figure out how to do that or put it in zip as suggested?

Thank you for all the help,

Ken

[Ken L.]

Hello,

I am posting the spread sheet on wildfire until i figure out how to make a zip of it!
here it is: http://www.mediafire.com/?z2wjyygicqd

Thank you,

Ken

[ChemistB]

Hi Ken,
You'll have more luck if you save the file as an xls for those of us who don't have Excel 2007.
To zip the file, use your Windows Explorer to find the file on your drive and right click on it. You should see the menu option of either zipping, winzip or compressing the file.

ChemistB