IF Function

F

Flipper

I have a report that summarizes activity from another worksheet. I want to
be able to update/change the formula if the date of the report changes. As
an example:

" =SUM(U:\Drew\[INVWKSH09.xls]1996'!$B$409:$B$411)"

and I want the formula to change so that whne the date of the report
changes, the formula would change to $B$411:$B$413

Thank for the help.
 
S

Shane Devenshire

Hi,

Do you always want it to increase by 2 rows? Where is the date changing?
So for example today is monday and when you open the file tomorrow you want
it to be two cells futher down. What about if its friday and you don't open
the file till tuesday? do you want it to increment by 2 cells or 8 or what?
You are really not giving us enough info.
 

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

Similar Threads

IF Function 1
Making part of a formula a variable 1
INDEX/MATCH skipping results 3
Copy formula from one worksheet to another to get value in 2nd wks 1
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Excel How to add numbers in same cell? 2
Help with worksheet function 2
With F1 value, look at A, if match or partial match return B 5

Top