Sorting SumIF
 

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)

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

Thanks

Slim


--
slim
------------------------------------------------------------------------
slim's Profile: http://www.excelforum.com/member.php...o&userid=28643
View this thread: http://www.excelforum.com/showthread...hreadid=559914

Sorting SumIF
 

slim wrote:
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)


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