Sorting SumIF

S

slim

Hi,

I'm tearing my hair out with trying to sort a column full of value
generated by SumIF's.

What I have is a list of about 1000 or so entries which are populate
from a larger list using a SUMIF because there are repeated entrie
that need to be summed.

Problem is that when i try and sort by any of the columns that ar
populated from the SUMIF the data gets messed up. What it looks lik
has happened is that excel is not changing the criteria (E12) in th
example below when it sorts the data meaning that the wrong data i
being shown against some entries.

=SUMIF('Datasheet'!$B:$B,$E12,'Datasheet'!J:J)

I would be really grateful if anyone can offer me any help.

Thanks

Sli
 
F

Franz Verga

slim said:
Hi,

I'm tearing my hair out with trying to sort a column full of values
generated by SumIF's.

What I have is a list of about 1000 or so entries which are populated
from a larger list using a SUMIF because there are repeated entries
that need to be summed.

Problem is that when i try and sort by any of the columns that are
populated from the SUMIF the data gets messed up. What it looks like
has happened is that excel is not changing the criteria (E12) in the
example below when it sorts the data meaning that the wrong data is
being shown against some entries.

=SUMIF('Datasheet'!$B:$B,$E12,'Datasheet'!J:J)
Click to expand...

Hi Slim,

maybe you're trying to sort just the column with the SUMIFs...

You have to sort all the table...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top