| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct absolute cell references
Hi,
I need to make the following formula "completely" absolute in it's cell references. =SUMPRODUCT(('Analysis Working'!$Y$2:$Y$2100="A")*('Analysis Working'!$C$2:$C$2100="Accounting & Legal")) I am currently running a macro on the sheet it refers to that deletes lines. Each time I run it the formula shanges the range. I have tried whole columns and found that doesn't work with SUMPRODUCT, nor does INDIRECT. Any suggestions would be greatly appreciated. Thanks Judy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Cell Absolute $ References Keep Changing themselves | Excel Discussion (Misc queries) | |||
| Absolute references in a cell | Excel Discussion (Misc queries) | |||
| Absolute References in cell formula | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Threaded Mode
