 |
 | 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 / January 2007Counting entries in column C, based on entries in column A
I would like to count the # of entries of a value in column C, grouped by values in column A. Binder Note Category AA01 abc 2 AA01 ccc 2 AA01 abc 2 AA01 ddd 3 AA22 aaa 1 AA22 ccc 2 Need to find the # of Category 2's , for every Binder # Do not have the nested IF's I have tried available at the moment, but I am getting close... Try this: E1 = some binder code like AA01 E2 = some category number like 2 =SUMPRODUCT(--(A2:A7=E1),--(C2:C7=E2)) Biff >I would like to count the # of entries of a value in column C, grouped > by values in column A. [quoted text clipped - 11 lines] > Do not have the nested IF's I have tried available at the moment, but I > am getting close...
|
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.