 |
 | 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 / General Excel Questions / May 2008Summing Fields 2
Ok, I need to elaborate from my previous e-mail. I have a worksheet that contains various columns, ex Formula Name, Quantity, Cost ect. I need to add together the cost per formula name in another cell. Example below Formula Name Quantity Cost Apples 1 11.00 Bananas 2 10.00 Apples 50 550.00 Strawberries 15 9.50 So, if I summed up Apples cost, it would be 561, Bananas would be 10 and Strawberries would be 9.50. Can anyone help? Thanks! Assuming your formula name is in column A and the cost is in column C. Try this... =SUMPRODUCT(--(A2:A10="Bananas")*(C2:C10)) > Ok, I need to elaborate from my previous e-mail. I have a worksheet that > contains various columns, ex Formula Name, Quantity, Cost ect. I need to [quoted text clipped - 10 lines] > would > be 9.50. Can anyone help? Thanks! Or =SUMIF(A2:A10,"Apples",C2:C10) > Ok, I need to elaborate from my previous e-mail. I have a worksheet that > contains various columns, ex Formula Name, Quantity, Cost ect. I need to [quoted text clipped - 10 lines] > would > be 9.50. Can anyone help? Thanks! Ok, that works, but now say I don't want to specify the formula name and I just want it to calculate based off of that entire column containing like 100 or more formula names... is that possible? Thanks so much!! > Or > [quoted text clipped - 14 lines] > > would > > be 9.50. Can anyone help? Thanks! You can make a list of unique names. that you can do by using advance filter. Select the range>go to Filter>Advance Filter>check Unique Records Only>check Copy to Another Location>Choose Location (for example D2). Once you have that list in column D starting in D2. in E2 enter the formula =SUMIF($A$2:$A$1000,D2,$C$2:$C$1000) Or =SUMPRODUCT(--($A$2:$A$1000=D2)*($C$2:$C$1000)) and drag it down. > Ok, that works, but now say I don't want to specify the formula name and I > just want it to calculate based off of that entire column containing like [quoted text clipped - 21 lines] >> > would >> > be 9.50. Can anyone help? Thanks! |
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.