| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using if or sum if to change range of sums
Hi,
I have a spread sheet which compares to ranges of data which changes during the course of the week. One range of data compares the current week as it builds against the previous week and I would like it to compare the same days as the week builds. Now I can do it manually by expanding the ranges each day, but I am aiming to automate this so it updates automatically. I believe something can be done using IF or SUMIF in some way but it is just not working for me at the moment. Help please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using if or sum if to change range of sums
I suggest that you use OFFSET function. See "my" thread:
http://groups.google.pl/group/micros...a57e3353104f2c -- Topola |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
| How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Linear Mode
