SteveMcd217
New Member
- Joined
- Oct 21, 2016
- Messages
- 5
This is my first post as is the first time I was unable to find an answer already here great forum.
I am working on a scorecard sheet and have named ranges for rows and columns. Rows are named for business functions and columns named for business units. The ranges allow me to simply use a function such as AVERAGE(PRINT) to retrieve an overall average of all print rows for all business units. What I would like to do is find a way to average each unit.
Print = rows 8 - 10 Business Units = Single Column Row 7 will hold Average so
Column "All" Row 7 Formula =Average(Print) gives me an average of all Business Units All rows of Print.
Column "HR" Row 7 I can use Average(D8:D10) to get what I need but would like to use combination of the "Print" and "HR" named ranges.
Thank you
I am working on a scorecard sheet and have named ranges for rows and columns. Rows are named for business functions and columns named for business units. The ranges allow me to simply use a function such as AVERAGE(PRINT) to retrieve an overall average of all print rows for all business units. What I would like to do is find a way to average each unit.
Print = rows 8 - 10 Business Units = Single Column Row 7 will hold Average so
Column "All" Row 7 Formula =Average(Print) gives me an average of all Business Units All rows of Print.
Column "HR" Row 7 I can use Average(D8:D10) to get what I need but would like to use combination of the "Print" and "HR" named ranges.
Thank you
