C
comam318
I am building a spreadsheet that will continue to grow in size. Th
basic outline of the spreadsheet is as follows:
A // B // C // D // E // F // G // H // I // J // K //
Sys Name // Project // Type of Bldg // Type of Work // Type of Price /
W/L // LNFT // CST // HRS // $/LNFT // HRs/LNFT //
Consept of the sheet is:
Column A will be grouped (using the Group command)
Column B is input for reference only, no lookup functions need apply
Column C is a Drop Down menu consisting of approximately 10 differen
types of Bldg.
Column D is a Drop Down menu consisting of approximately 5 differen
types of work.
Column E is a Drop Down menu consisting of approximately 6 differen
types of pricing.
Column F is a Drop Down menu with either Win or Lost.
Column G, H and I is user input.
Column J and K are simply math functions, J=H/G and K=I/G
Row 1 is Column names as outlined above.
Row 2 is a summary of System 1.
Rows 3 - ?? is data for system 1.
Sample Data:
System 1
// Project 1 // Bldg1 // Work1 // Price1 // Lost // 11484
// $49,045 // 3133 // (Formula Result) // (Formula Result)
// Project 2 // Bldg1 // Work2 // Price1// Win // 1019 //
$4,698 // 413 // (Formula Result) // (Formula Result)
// Project 3 // Bldg1 // Work1 // Price1 // Lost // 6594 /
$26,789 // 1710 // (Formula Result) // (Formula Result)
I am going to group the data under System 1 with the Group comman
becuase I will have multiple systems and not every project has eac
system. I want to summarize the data under each system by multipl
methods. I want to find the Average, Min, Max, and Mean based on
selection in the System row.
Column A is system name.
Column B is blank
Column C, D, E and F is Drop Down of same info from above.
Column G is a Drop Down of "Average", "Low", "High" and "Mean".
Column H, I, J and K perform the formula based on selections from C
G.
I am looking for a formula or CODE to perform the functions liste
above. It must be able to perform the formula in column G, based o
selection from Colum C - F weither there is a selection or not. (Ex.
if C - F are blank and G is Average then it returns the average of al
data below. Ex 2. if C is blank and D is Work1 and E - F are blan
and G is Mean then the Mean of Work1 is displayed.
I hope this makes some sort of sense and that someone can help me out.
Thank you for any assistance
basic outline of the spreadsheet is as follows:
A // B // C // D // E // F // G // H // I // J // K //
Sys Name // Project // Type of Bldg // Type of Work // Type of Price /
W/L // LNFT // CST // HRS // $/LNFT // HRs/LNFT //
Consept of the sheet is:
Column A will be grouped (using the Group command)
Column B is input for reference only, no lookup functions need apply
Column C is a Drop Down menu consisting of approximately 10 differen
types of Bldg.
Column D is a Drop Down menu consisting of approximately 5 differen
types of work.
Column E is a Drop Down menu consisting of approximately 6 differen
types of pricing.
Column F is a Drop Down menu with either Win or Lost.
Column G, H and I is user input.
Column J and K are simply math functions, J=H/G and K=I/G
Row 1 is Column names as outlined above.
Row 2 is a summary of System 1.
Rows 3 - ?? is data for system 1.
Sample Data:
System 1
// Project 1 // Bldg1 // Work1 // Price1 // Lost // 11484
// $49,045 // 3133 // (Formula Result) // (Formula Result)
// Project 2 // Bldg1 // Work2 // Price1// Win // 1019 //
$4,698 // 413 // (Formula Result) // (Formula Result)
// Project 3 // Bldg1 // Work1 // Price1 // Lost // 6594 /
$26,789 // 1710 // (Formula Result) // (Formula Result)
I am going to group the data under System 1 with the Group comman
becuase I will have multiple systems and not every project has eac
system. I want to summarize the data under each system by multipl
methods. I want to find the Average, Min, Max, and Mean based on
selection in the System row.
Column A is system name.
Column B is blank
Column C, D, E and F is Drop Down of same info from above.
Column G is a Drop Down of "Average", "Low", "High" and "Mean".
Column H, I, J and K perform the formula based on selections from C
G.
I am looking for a formula or CODE to perform the functions liste
above. It must be able to perform the formula in column G, based o
selection from Colum C - F weither there is a selection or not. (Ex.
if C - F are blank and G is Average then it returns the average of al
data below. Ex 2. if C is blank and D is Work1 and E - F are blan
and G is Mean then the Mean of Work1 is displayed.
I hope this makes some sort of sense and that someone can help me out.
Thank you for any assistance