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.
 
can u post some sample data here, so that we can suggest u the way to do the
thing
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum last 3 numbers greater that 0 in a range 0
Row() and SUM() ?s 7
Summing rows using formulas with variables 1
series of sums in a long spreadsheet 1
Summing a variable number of rows 3
Insert a Row and then Sum 1
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Variable row groupings 3

Back
Top