LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Marc
 
Posts: n/a
Default How/can you create absolute values for cell references that have sum(a1:a4)?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create new series (on the same chart) for every change of values in a combobox uriel78 Charts and Charting in Excel 5 April 15th 05 12:08 AM
Create a Chart with Values from Array AND NOT from Ranges syrhus Charts and Charting in Excel 5 March 19th 05 02:37 AM
How do I get absolute values for a range of cells? Terry Excel Discussion (Misc queries) 3 March 2nd 05 03:54 PM
How do I create a formula to add values from specific fields? Greg Excel Worksheet Functions 1 December 14th 04 03:10 PM
How do i create a "look up" to sum values in excel? tbaldwin Excel Worksheet Functions 1 November 10th 04 05:17 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"