| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2003 function moved to 2007 unable to change absolute references
Hi,
I have this function =SUM(IF($D$25:$D$993="x",IF($B$25:$B$976=""&A3,1), 0)) from excel 2003 and now have converted the spreadsheet to 2007. I have inserted rows and now need to change $D$25 and $b$25 to reference row 22. Or is there a better way to do this. count number of x's from d22:d900 if b22:b900 equals a3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change relative to absolute references in a block of cells | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Excel 2007 chart series - unable to use structured references | Charts and Charting in Excel | |||
| change a long column of references from relative to absolute | New Users to Excel | |||
| Pivot tables Excel 2003 absolute references | Excel Discussion (Misc queries) | |||
Threaded Mode
