Sum based on condition
Name Amount Total A 10 A 5 A 15 B 50 B 20 B 10
Now in third column I would like to sum the total Amount for Distinct Name column values, something like:
SUM all values in Amount column where Name column values are A,B and so on (Distinct Name column values)
Can anyone help me on this?
you can use sumif
=SUMIF(A1:A5,"A",B1:B5)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks vlady for the solutionBut I want =SUMIF(A1:A5,"A",B1:B5) "A" field to be dynamic and copy this formula to the entire column C. Can this be achieved?
yes if i got you correct like this..
sumifdummy.xlsx
I would go with pivot tables
Life's a spreadsheet, Excel!
Say thanks, Click *
Awesome vlady and Ace_XL :D Thanks a lot
btw Ace_XL can you please tell me how can I do that pivot table on my own?
Some reading on pivot tables..easy to learn!
http://office.microsoft.com/en-us/ex...001034632.aspx
www.cpearson.com/excel/pivots.htm
your welcome.
thanks.
edit : late posting..
---------- Post added at 02:34 PM ---------- Previous post was at 01:55 PM ----------
thanks for the rep...can you mark this thread " SOLVED"
look at below my signature for steps.
thanks again for your time.
Hi vlady,
Your formula in cell G2 has a problem. You had it as:
=SUMIF(A2:$A$16,F2,$B$2:$B$16)
And when you pulled it down it became:
=SUMIF(A3:$A$16,F3,$B$2:$B$16)
I caught this by looking at the Pivot Table posted by Ace_XL and found the B and C sums different.
I believe you need a dollar sign in front of the 2 in A2. This made your answer wrong.
The correct formula should have been:
=SUMIF($A$2:$A$16,F2,$B$2:$B$16)
and then pull it down.
---------- Post added at 11:55 PM ---------- Previous post was at 11:52 PM ----------
@ vlady -
Read my post above to see why you got the wrong answer. You might PM the OP and make sure he isn't doing important financial work with your formula.
One test is worth a thousand opinions.
OH..,
didn't notice that i just hit F4...
PM OP now. thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks