Hello,
I'm including a sample file to illustrate what I need. The formulas in rows 26 to 30 need to calculate the quantities in the salary columns. I want to enter the formulas in the first salary column and then copy them over to the other columns. Rows 23-25 already have functions in them.
The calculations are as follow:
row 26: will sum the quantities in the column but exclude the number of cells stated in row 25 from the top of the set and the bottom of the set . Each column has a different amount of rows with data. (So this will sum the cells from the yellow cell at the top of the column to the bottom yellow cell.) (Workbook will not have yellow cells, this is for illustration only, although if it could be highlighted through a function it would be fantastic.)
row 27:is a count of the range summed in row 26
row 28: is the highest amount in that range
row 29: is the lowest amount in the range summed in row 26
row 30: is the average of that range
I hope someone can help. Please
Bookmarks