On Aug 27, 2:16*pm, 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

Have you tried using the SUBTOTAL function? Using
=SUBTOTAL(109,A1:A10) should ignore any hidden values when calculating
the total in the range. Check out the help file for other
examples ...

Rob