 |
 | 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 / April 2008sumif values are same
How do I sum column A if the value C is common? A B C 15.2 2 aa1 23.0 1.5 aa1 12.3 1.5 aa1 0.7 1.5 aa1 15.2 2 bb1 15.2 2 cc1 23.0 1.5 cc1 12.3 1.5 cc1 0.7 1.5 cc1 Try this: =SUMIF(C:C,"aa1",A:A) will add all the values in column A which have a value of aa1 in the corresponding cell of column C. Hope this helps. Pete > How do I sum column A if the value C is common? > [quoted text clipped - 10 lines] > 12.3 1.5 cc1 > 0.7 1.5 cc1 Almost there, but the value is not always aa1, bb1, cc1. I try subsitute "aa1" with the cell e.g C2, C3, C4 and so forth at column 'D', but I dont want to see repeating total sum at 'D' column as highlight in BOLD. Note at D1 and D10, both must be shown as their C column are different > A B C D 1 15.2 2 aa1 51.2 2 23.0 1.5 aa1 51.2 3 12.3 1.5 aa1 51.2 4 0.7 1.5 aa1 51.2 5 15.2 2 bb1 15.2 6 15.2 2 cc1 57.2 7 18.0 1.5 cc1 57.2 8 12.3 1.5 cc1 57.2 9 11.7 1.5 cc1 57.2 10 15.2 2 dd1 51.2 11 23.0 1.5 dd1 51.2 12 12.3 1.5 dd1 51.2 13 0.7 1.5 dd1 51.2 Try this: =SUMIF(C:C,"aa1",A:A) will add all the values in column A which have a value of aa1 in the corresponding cell of column C. Hope this helps. Pete On Apr 4, 9:13 am, "crapit" <biggerc...@yahoo.com> wrote: > How do I sum column A if the value C is common? > [quoted text clipped - 10 lines] > 12.3 1.5 cc1 > 0.7 1.5 cc1 Put this formula in D1: =SUMIF(C:C,C1,A:A) and this one in D2: =IF(C2=C1,"",SUMIF(C:C,C2,A:A)) Then copy the second formula down as required. Hope this helps. Pete > Almost there, but the value is not always aa1, bb1, cc1. I try subsitute "aa1" with the cell e.g C2, C3, C4 and so forth at column 'D', but I dont want to see repeating total sum at 'D' column as highlight in BOLD. Note at D1 and D10, both must be shown as their C column are different> A B C D > [quoted text clipped - 44 lines] > > - Show quoted text - U R marvellous. Thanks for the great help Put this formula in D1: =SUMIF(C:C,C1,A:A) and this one in D2: =IF(C2=C1,"",SUMIF(C:C,C2,A:A)) Then copy the second formula down as required. Hope this helps. Pete On Apr 4, 3:18 pm, "crapit" <biggerc...@yahoo.com> wrote: > Almost there, but the value is not always aa1, bb1, cc1. I try subsitute > "aa1" with the cell e.g C2, C3, C4 and so forth at column 'D', but I dont [quoted text clipped - 48 lines] > > - Show quoted text - Thanks for feeding back - glad it worked for you. Pete > U R marvellous. Thanks for the great help Can you please explain a little clearer perhaps with an example of the summation result from the dataset posted > How do I sum column A if the value C is common? > [quoted text clipped - 10 lines] > 12.3 1.5 cc1 > 0.7 1.5 cc1
|
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.