I have a large amount of rows I want to sum; for which I use the SUM tool.
However, within this group of rows there are a number of rows that I don't
want to be included as part of the sum. On the contrary I want the sum of
these rows, which are the exception rows, to be added together and subtracted
from the SUM of the large group of rows.

How would I go about doing this? Any help you could give me is greatly
appreciated. Thank you.

Use SUMIF()

= SUMIF(A:A,"Yes",B:B)
The above formula will sum all rows of ColB if the corresponding rows in Col
A is "Y" . So you can use SUMIF()-SUMIF() with two criterias...

If this post helps click Yes
---------------
Jacob Skaria


"lydia's" wrote:

I have a large amount of rows I want to sum; for which I use the SUM tool.
However, within this group of rows there are a number of rows that I don't
want to be included as part of the sum. On the contrary I want the sum of
these rows, which are the exception rows, to be added together and subtracted
from the SUM of the large group of rows.

How would I go about doing this? Any help you could give me is greatly
appreciated. Thank you.

Thank you for your response. What if the "exception rows I mentioned are not
all next to one another? They are scattered all around within the large
group of rows that will be summed.

Thank you.

"Jacob Skaria" wrote:

Use SUMIF()

= SUMIF(A:A,"Yes",B:B)
The above formula will sum all rows of ColB if the corresponding rows in Col
A is "Y" . So you can use SUMIF()-SUMIF() with two criterias...

If this post helps click Yes
---------------
Jacob Skaria


"lydia's" wrote:

I have a large amount of rows I want to sum; for which I use the SUM tool.
However, within this group of rows there are a number of rows that I don't
want to be included as part of the sum. On the contrary I want the sum of
these rows, which are the exception rows, to be added together and subtracted
from the SUM of the large group of rows.

How would I go about doing this? Any help you could give me is greatly
appreciated. Thank you.

Fine; let that be scattered. What is the criteria to identify these rows...

If this post helps click Yes
---------------
Jacob Skaria


"lydia''s" wrote:

Thank you for your response. What if the "exception rows I mentioned are not
all next to one another? They are scattered all around within the large
group of rows that will be summed.

Thank you.

"Jacob Skaria" wrote:

Use SUMIF()

= SUMIF(A:A,"Yes",B:B)
The above formula will sum all rows of ColB if the corresponding rows in Col
A is "Y" . So you can use SUMIF()-SUMIF() with two criterias...

If this post helps click Yes
---------------
Jacob Skaria


"lydia's" wrote:

I have a large amount of rows I want to sum; for which I use the SUM tool.
However, within this group of rows there are a number of rows that I don't
want to be included as part of the sum. On the contrary I want the sum of
these rows, which are the exception rows, to be added together and subtracted
from the SUM of the large group of rows.

How would I go about doing this? Any help you could give me is greatly
appreciated. Thank you.

The title of these rows is "received". Also, these "exception" rows are in
black; on the contrary all the other rows are red.

Is there any more information you need to know to help me with this? Maybe
I'm not explaining what I want clearly.

can u post some sample data here, so that we can suggest u the way to do the
thing

"lydia's" wrote:

I have a large amount of rows I want to sum; for which I use the SUM tool.
However, within this group of rows there are a number of rows that I don't
want to be included as part of the sum. On the contrary I want the sum of
these rows, which are the exception rows, to be added together and subtracted
from the SUM of the large group of rows.

How would I go about doing this? Any help you could give me is greatly
appreciated. Thank you.