sum of rows with exception of row x, y, z...

L

lydia's

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.
 
J

Jacob Skaria

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
 
L

lydia''s

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.
 
J

Jacob Skaria

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

If this post helps click Yes
 
L

lydia''''s

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

lydia''''s

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

YESHWANT

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