 |
 | 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 / Worksheet Functions / March 2008Question with a formula
Hi there, I am trying to create a formula for the data below that would add volumes in column C that coorespond to the "Wash" and "Blend" (not Blend50/50) in Column B seperately for the categories Concrete and Rock. Is there a formula that could do this for me? A B C 1 concrete Acid 1,002.00 2 concrete Wash 7,350.00 3 concrete Blend 9,996.00 4 concrete Blend50/50 96,178.00 5 rock Acid 500 6 rock Wash 7,140.00 7 rock Blend 10,351.00 8 rock Blend50/50 108,904.00 Thanks! Do you mean you want to sum column C if column B is "Wash" OR "Blend"? =SUMIF(B1:B100,"wash",C1:C100)+SUMIF(B1:B100,"blend",C1:C100) or if you wanted separate formulas for those two criteria, then just break the formula apart. HTH, Paul > Hi there, I am trying to create a formula for the data below that would > add [quoted text clipped - 14 lines] > > Thanks! Thank you Paul, how do I have it do this for just the figures that contain Concrete or Rock, I actually have several other names in column A and need to add the Wash and Blend for each name seperately from each other. > Do you mean you want to sum column C if column B is "Wash" OR "Blend"? > =SUMIF(B1:B100,"wash",C1:C100)+SUMIF(B1:B100,"blend",C1:C100) [quoted text clipped - 23 lines] > > > > Thanks! That will use a different formula. There may be a different way of doing it, but here's one way. =SUMPRODUCT(--(A1:A100="Concrete"),--(B1:B100="Wash"),C1:C100)+SUMPRODUCT(--(A1:A100="Concrete"),--(B1:B100="Blend"),C1:C100) If you have your criteria in a cells, (ex. X1="Concrete" Y1="Wash" Z1="Blend"), then: =SUMPRODUCT(--(A1:A100=X1),--(B1:B100=Y1),C1:C100)+SUMPRODUCT(--(A1:A100=X1),--(B1:B100=Z1),C1:C100) Regards, Paul > Thank you Paul, how do I have it do this for just the figures that contain > Concrete or Rock, I actually have several other names in column A and need [quoted text clipped - 30 lines] >> > >> > 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
|
©2009 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.