Hi all,

I have a sheet with 305 rows with data associated with each row in 10
columns. I highlighted approximately 100 of the rows. I would like to
calculate summary numbers for the total sheet (305 rows) and also for
the highlighted 100 rows. The highlighted rows are not consecutive, so
there are unhighlighted rows in between the highlighted ones.

I thought about grouping the highlighted rows, but I'm not sure how to
write a formula for only those rows. For example, I would like to use
the =count() to count how many total rows there are and also how many
are highlighted. How would I go about doing this?

I know I can just have 2 sheets - one highlighted and one total, but I
would like the flexibility of having all the data on 1 sheet if
possible.

Thanks in advance!


--
deacs
------------------------------------------------------------------------
deacs's Profile: http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=506311