If you had a column that included the supervisors name, you could probably
get the result with SUMPRODUCT. Come back if you have any questions. Give
specifics of the cells with the Supervisors names, and Scores that are to be
summed.
--
HTH,
Barb Reinhardt



"Trish Smith" wrote:

Hi everyone,

I'm not sure that the subject line explains anything but what I would like
to do is to be able to sum a range of non-contiguous cells BUT if rows are
hidden not to sum the values in those cells.

I need to calculate scores from employees - supervisors may have 1 to 5
people reporting to them and I want to send out a generic workbook so I have
a macrobuttons on sheet 1 for them to select number of employees and this
hides the appropriate number of rows. Supervisors can then enter scores for
just those employees and most importantly calculates the score

The range is in Column H starting at Row 9 and then every other row to row
17 and cells are formatted as numbers.

There are other scores on this page not relating to individual employees and
these also have to add to the total.

At the moment the scores are summed in C45 and Averaged in D45 but I'm
guessing that the calculation will need to be done from a calculate
macrobutton.

If annyone could help that would be brilliant :-)

Thank you

--
Trish