LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BigTim
 
Posts: n/a
Default sum values in a data group

I would like to find a way to dynamically sum values in a datagroup so that
if I add or remove items from the the grou the SUM value is updated.

Example:
I create a list of items in a price sheet.

Widget Parts Price$6
part1 $1
part2 $2
part3 $3

I group them all together:
data group and outline grouip

I want to sum all the parts so that no matter how many parts I add or remove
the Price$ will automically update. Currently, if I add or remove parts I
have to update the SUM() for Price$.

 
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
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
How do I show both data labels and values? Carter Devereaux Charts and Charting in Excel 1 June 26th 05 07:12 PM
pivot table with selection values not included in the base data confused Charts and Charting in Excel 0 June 21st 05 02:42 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM


All times are GMT +1. The time now is 07:17 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"