| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
I'm working on formula on one sheet that reference another sheet. If I use
sum and I drag the cells I get a1:a4. I can click one each cell independently and get a1+a2+a3+a4 but none of these are absolute. I've tried using paste special but it kicks me out of the original formula. I have spent to much time trying to make sure the values are absolute. Marc <Andy B wrote in message ... Hi If I understand you correctly (forgive me if I don't!) you can use Copy and Paste Special Values on sums in exactly the same way as references. An alternative is to select the cell(s) and hit F2, F9, Enter. -- Andy. "Marc" wrote in message link.net... Many of my references link to another work sheet and "paste special" gives me absolute values but you can't at least that I know of use these easily in "sum". Marc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
| Create a Chart with Values from Array AND NOT from Ranges | Charts and Charting in Excel | |||
| How do I get absolute values for a range of cells? | Excel Discussion (Misc queries) | |||
| How do I create a formula to add values from specific fields? | Excel Worksheet Functions | |||
| How do i create a "look up" to sum values in excel? | Excel Worksheet Functions | |||
Threaded Mode
