 |
 | 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 / February 2007IF Statements
I need to count items in one column when the word active appears in another column. What I am trying to do is count all members who are "active" and who have a shunt. Active and Shunt are in different columns and I know that I could just filter the sheet by the columns, but I was hoping for an easier method. By developing a formula. =sumproduct((a2:a22="active")*(b2:b22="shunt"))  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I need to count items in one column when the word active appears in another > column. [quoted text clipped - 5 lines] > filter the sheet by the columns, but I was hoping for an easier method. By > developing a formula. One way: =SUMPRODUCT(--(A1:A1000="active"),--(B1:B1000="shunt")) See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of the "--" You might also consider using a Pivot Table, if you have multiple items to count. > I need to count items in one column when the word active appears in another > column. [quoted text clipped - 3 lines] > filter the sheet by the columns, but I was hoping for an easier method. By > developing a formula. These formulas wanted to sum the two columns or multiply them. I am wanting to onlu sum one column if the other has a particular text in it. > I need to count items in one column when the word active appears in another > column. [quoted text clipped - 3 lines] > filter the sheet by the columns, but I was hoping for an easier method. By > developing a formula. Did you actually try it? I suspect not. > These formulas wanted to sum the two columns or multiply them. I am wanting > to onlu sum one column if the other has a particular text in it. Both fromulas work to COUNT, not SUM if BOTH columns meet the criteria on the SAME row. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > These formulas wanted to sum the two columns or multiply them. I am > wanting [quoted text clipped - 11 lines] >> By >> developing a formula. |
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.