software

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: www.excelforum.com/member.php...foamp;userid=2321
View this thread: www.excelforum.com/showthread...hreadid=506311What do you mean by quot;highlightedquot;. 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?

--
Ian
--
quot;deacsquot; gt; wrote in
message ...
gt;
gt; Hi all,
gt;
gt; I have a sheet with 305 rows with data associated with each row in 10
gt; columns. I highlighted approximately 100 of the rows. I would like to
gt; calculate summary numbers for the total sheet (305 rows) and also for
gt; the highlighted 100 rows. The highlighted rows are not consecutive, so
gt; there are unhighlighted rows in between the highlighted ones.
gt;
gt; I thought about grouping the highlighted rows, but I'm not sure how to
gt; write a formula for only those rows. For example, I would like to use
gt; the =count() to count how many total rows there are and also how many
gt; are highlighted. How would I go about doing this?
gt;
gt; I know I can just have 2 sheets - one highlighted and one total, but I
gt; would like the flexibility of having all the data on 1 sheet if
gt; possible.
gt;
gt; Thanks in advance!
gt;
gt;
gt; --
gt; deacs
gt; ------------------------------------------------------------------------
gt; deacs's Profile:
gt; www.excelforum.com/member.php...foamp;userid=2321
gt; View this thread: www.excelforum.com/showthread...hreadid=506311
gt;

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

quot;Highlightedquot; just means that I have colored these rows with a color to
distinguish them from the others. Each row represents a product. I have
quot;highlightedquot; the about 100 of the products. I would like to be able to
write formulas that only pertain to these 100 products. Unfortunately,
there are no common features of the highlighted rows. They represent
specific products that I would like to group together and spike out
from the overall product mix.

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

Thanks again.--
deacs
------------------------------------------------------------------------
deacs's Profile: www.excelforum.com/member.php...foamp;userid=2321
View this thread: www.excelforum.com/showthread...hreadid=506311OK. 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,quot;Xquot;)
To add the values in column C for rows highlighted
=SUMIF(K1:K305,quot;Xquot;,C1:C305)

--
Ian
--
quot;deacsquot; gt; wrote in message
...
gt;
gt; Thanks for the reply and I apologize for not being clear.
gt;
gt; quot;Highlightedquot; just means that I have colored these rows with a color to
gt; distinguish them from the others. Each row represents a product. I have
gt; quot;highlightedquot; the about 100 of the products. I would like to be able to
gt; write formulas that only pertain to these 100 products. Unfortunately,
gt; there are no common features of the highlighted rows. They represent
gt; specific products that I would like to group together and spike out
gt; from the overall product mix.
gt;
gt; Will you please show me what you mean by adding a helper column? That
gt; might do the trick, but I'm unclear how to go about achieving this.
gt;
gt; Thanks again.
gt;
gt;
gt; --
gt; deacs
gt; ------------------------------------------------------------------------
gt; deacs's Profile:
gt; www.excelforum.com/member.php...foamp;userid=2321
gt; View this thread: www.excelforum.com/showthread...hreadid=506311
gt;