Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula syntax
I am usually very good at figuring these out but cannot for the life of me
get this one. First off I am using Excel 2003 on a XP Pro machine. I have a workbook with 30 sheets in it. 23 of these are for working days of the month. They are named in the following fashion: May01, May04, May 05, etc. I have another sheet that I want to have calculate the totals from each daily page. I also want this to be dynamic in the formulas so when the next month comes around I do not have to spend a great deal of time setting up the formulas. I have the same daily sheet names in a header (row B) on my totals sheet. So I have tried to write a formula that is something like this: =B2!L34 B2 currently equals May01 and L34 is the place on the daily sheets that contains the total I need to place on my totals sheet. I found a function called INDIRECT that is supposed to take a cell's text and use it as a part of the formula, but keep getting REF when I try this out. This all seems to be just a syntax error and I am overlooking it. PLEASE HELP. -David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula syntax. | Excel Discussion (Misc queries) | |||
Syntax of formula | Excel Worksheet Functions | |||
Formula Syntax | Excel Worksheet Functions | |||
Formula syntax {;;;} | Excel Worksheet Functions | |||
Syntax For Conditional Formula | Excel Worksheet Functions |