 |
 | 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 2004Sum cells flagged by other cells
I need to know how to sum cell values in column b, if the corresponding row in column c value is equal to 1. Column B contains the data, column C contains flags to use or not use the data. All help is greatly appreciated. =SUMIF(C2:C50,1,B2:B50)  SignatureRegards, Peo Sjoblom > I need to know how to sum cell values in column b, if the corresponding > row in column c value is equal to 1. Column B contains the data, column [quoted text clipped - 4 lines] > Excel Templates, Training, Add-ins & Business Software Galore! > Free Excel Forum http://www.ozgrid.com/forum *** Hi =SUMIF(C:C,1,B:B) -- Arvi Laanemets (Don't use my reply address - it's spam-trap) > I need to know how to sum cell values in column b, if the corresponding > row in column c value is equal to 1. Column B contains the data, column [quoted text clipped - 4 lines] > Excel Templates, Training, Add-ins & Business Software Galore! > Free Excel Forum http://www.ozgrid.com/forum *** |
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.