Help with Group/Ungroup

[deacs]

Hi all,

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

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

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

Thanks in advance

 

[Ian]

What do you mean by "highlighted". Is there some common feature of the
highlighted rows? Can a formula be written to identify the selected rows?
Can you identify the highlighted cells with a value in an adjacent column (a
helper column)? We will need a little more information to be able to help?

 

[deacs]

Thanks for the reply and I apologize for not being clear.

"Highlighted" just means that I have colored these rows with a color t
distinguish them from the others. Each row represents a product. I hav
"highlighted" the about 100 of the products. I would like to be able t
write formulas that only pertain to these 100 products. Unfortunately
there are no common features of the highlighted rows. They represen
specific products that I would like to group together and spike ou
from the overall product mix.

Will you please show me what you mean by adding a helper column? Tha
might do the trick, but I'm unclear how to go about achieving this.

Thanks again

 

[Ian]

OK. You mentioned 10 columns of data and 305 rows. If the columns are A-J,
then in column K type X in each row you want to highlight (and calculate
on). I'm also assuming rows are 1 to 305. Change the rows and columns if
necessary.

To count the number of rows highlighted =COUNTIF(K1:K305,"X")
To add the values in column C for rows highlighted
=SUMIF(K1:K305,"X",C1:C305)