 |
|
|
 |
New Member
|
|
Feb 23, 2009, 10:06 PM
|
|
Sort a Column & sum the range with same value during the sort
Hi, I'm trying to sort a data table by Grades & then sum the totals of the cell with same Grade. The table consists of this headers: Date, DD#, Grade, Bags so what I'm trying to do is to come up with a formula that can sort by Grade & then add the total Bags against that particular Grade and display on the summary sheet.
Any help is greatly appreciated!
|
|
 |
Software Expert
|
|
Feb 23, 2009, 10:16 PM
|
|
That's a SUMPRODUCT formula, or a SUMIF, either will work.
=SUMIF($C$2:$C$10,F2,$D$2:$D$10)
vs.
=SUMPRODUCT(--($C$2:$C$10=F2),$D$2:$D$10)
Given a choice, I would opt for the SUMIF since it is not volatile, like SUMPRODUCT.
But SUMPRODUCT can be fed additional filter criteria. For instance you could get all the As for a particular date by adding another section.
=SUMPRODUCT(--($C$2:$C$10=F2),--(B2:B10="DD1"),$D$2:$D$10)
(attachment with sample)
|
|
 |
New Member
|
|
Feb 23, 2009, 10:28 PM
|
|
 Originally Posted by JBeaucaire
That's a SUMPRODUCT formula, or a SUMIF, either will work.
=SUMIF($C$2:$C$10,F2,$D$2:$D$10)
vs.
=SUMPRODUCT(--($C$2:$C$10=F2),$D$2:$D$10)
Given a choice, I would opt for the SUMIF since it is not volatile, like SUMPRODUCT.
But SUMPRODUCT can be fed additional filter criteria. For instance you could get all the As for a particular date by adding another section.
=SUMPRODUCT(--($C$2:$C$10=F2),--(B2:B10="DD1"),$D$2:$D$10)
(attachment with sample)
Thank you so much JBeaucaire! That is exactly what I needed...
Thanks
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
I need some sort of explanation.
[ 2 Answers ]
I would like to get some input on what is going on here, as the more it happens, the more I am interested in the paranormal and such. The most striking thing that has happened is that while I was in the Memphis Job Corps Center in '99, I gave my camera to a friend to take a picture of me and...
How can I sort data on a Hidden column in Excel?
[ 2 Answers ]
I have a spreadsheet that has a pivot table in it.
Each record has a time group column and a time nbr column in the pivot table.
(i.e. Timegroup = 90 days before and a timenbr of 1 is assigned to this group,
Timegroup = 60 days before and a timenbr of 2 is assigned to this group,...
How to sort it?Please help!
[ 1 Answers ]
ok heres the low down,im 14 btw just get to know me a bit he he.. been going out with my gf (charlotte) for 8 months now i really really love her might think its puppy love but she kinda my first ...not going to go into detal about what we do. :D we wernt excaclly m8 befour we went out coz we...
View more questions
Search
|