Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula partial change
Is there a way to carry a formula down cells and have only part of the
formula change. Need to reference the cell next to it, but not the lookup formula. need to keep column C from changing, but need to have B Cell Reference change, as I drop formula down. I have 60-80 cells, and this get tedious. =SUMPRODUCT(--EXACT('3-2007'!C1:C551,B54))+SUMPRODUCT(--EXACT('2-2007'! C1:C551,B54))+SUMPRODUCT(--EXACT('1-2007'!C1:C551,B54))+SUMPRODUCT(-- EXACT('12-2006'!C1:C551,B54)) Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to BOLD partial number | New Users to Excel | |||
If Formula When Contains Partial Word | Excel Worksheet Functions | |||
Partial Text Color Change in Cell | Excel Discussion (Misc queries) | |||
Formula to calculate partial payments | Excel Worksheet Functions | |||
format partial formula | Excel Programming |