Hello, I am sorry if this is not the right place for this question (its my 2nd post and my boss is giving me a hard time) .
sum data.png
A 1
A 1 I HAVE THIS DATA .
A 1
B 2
B 2
C 3
C 3
C 3
A 3
B 4 HOW TO MAKE THEM SUM LIKE THIS ?
C 9
forum.xlsx - this is my data .
Last edited by svetlich; 10-19-2012 at 11:12 AM.
Look at the SUMIF function.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Try
=SUMIF(B2:B9,B12,C2:C9)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
i have only this data forum.xlsxOriginally Posted by fotis1991
Last edited by svetlich; 10-19-2012 at 11:06 AM.
your explanations arnt very clear but see is this helps
forum.xlsx
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
You are the best !
THANKS MAN , you are THE BEST. CAN YOU LOCK AT THIS : http://www.excelforum.com/excel-form...gn-in-1-a.html
glad to help
remember to mark solved and to hit the star for any posts that help
When i send my reply, you had upload only a picture! Not a workbook.
And your picture IS NOT is not the same as your workbook!
So, look your picture that you uploaded for us . If you put my formula in C12, it is works fine.
Its my mistake that i dont upload in first time the workbook. You help me too. thank you. I realy mean this guys , you saved me a lot of time .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks