 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Conditional addition of cells
I want to add the sales (column B) of the people in column A. A B James 23 Randy 43 Paul 12 James 40 Paul 50 ...and get this result: C D James 63 Randy 43 Paul 62 Only the result in column D needs to be calculated. Any help much appreciated. Since you state that: "Only the result in column D needs to be calculated" I'll assume that you have already entered the list of unique names in Column C. So, in D1 enter this: =Sumif(A$1:A$5,C1,B$1:B$5) And copy down.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- >I want to add the sales (column B) of the people in column A. > [quoted text clipped - 14 lines] > > Any help much appreciated. Thanks for the hint. I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5) "RagDyer" <ragdyer@cutoutmsn.com> kirjoitti viestissä:%239ADD00cIHA.1164@TK2MSFTNGP02.phx.gbl... > Since you state that: > "Only the result in column D needs to be calculated" [quoted text clipped - 24 lines] >> >> Any help much appreciated. You're welcome. and appreciate the feed-back. SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- Thanks for the hint. I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5) "RagDyer" <ragdyer@cutoutmsn.com> kirjoitti viestissä:%239ADD00cIHA.1164@TK2MSFTNGP02.phx.gbl... > Since you state that: > "Only the result in column D needs to be calculated" [quoted text clipped - 24 lines] >> >> Any help much appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.