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

  • Thread starter Thread starter lydia's
  • Start date Start date
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.
 
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
 
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.
 
Fine; let that be scattered. What is the criteria to identify these rows...

If this post helps click Yes
 
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.
 
Back
Top