 |
 | 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 / November 2006count entries
Hi! given the table below - example - John 2 Fred 3 Eric 1 Eric 3 John 4 Eric 2 Fred 2 Eric 1 1. I want to count how often a name occurs e.g. Eric = 4 2. I want to calculate the sum of the values for a certain person e.g. Eric = 7 Any solution? Thanks! tom look in the help index for COUNTIF and SUMIF  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hi! > [quoted text clipped - 20 lines] > > tom =COUNTIF([range],"Eric") --> replace [range] with the correct range on your worksheet. =SUMIF([range],"Eric") --> replace [range] with the correct range on your worksheet. SignatureBrevity is the soul of wit. > Hi! > [quoted text clipped - 20 lines] > > tom Hi! Thanks for the answers! still encountering problems with SUMIF. The actual table contains sevrel colums with data. an example: A B C 1 green red 2 John 4 2 3 Fred 1 3 4 Eric 111 1 5 Eric 5 3 6 John 5 4 7 Eric 5 2 8 Fred 5 2 9 Eric 5 1 =SUMIF(A2:C9,"John") The result is 0, how to get 2+4=6 as a result? Thanks a lot! tom > =COUNTIF([range],"Eric") --> replace [range] with the correct range on your > worksheet. [quoted text clipped - 26 lines] > > > > tom =SUMPRODUCT((A2:A18="john")*B2:C18) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hi! Thanks for the answers! > [quoted text clipped - 53 lines] >> > >> > tom Thanks a lot! next step makes it more complicated.. given a list of years instead of names. A B C green red 1 1974 2 2 2 1985 6 1 3 1983 2 3 4 1974 1 3 5 1983 2 1 6 1974 4 3 How to calculate how many red in 1974. In this case the formula previously given formula gives 0 as a result. How to solve this? (The result should be 8) Thanks! tom > =SUMPRODUCT((A2:A18="john")*B2:C18) > [quoted text clipped - 55 lines] > >> > > >> > tom sorry, seems now it works.. thanks anyway! > Thanks a lot! > [quoted text clipped - 78 lines] > > >> > > > >> > tom glad to help SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > sorry, seems now it works.. thanks anyway! > [quoted text clipped - 84 lines] >> > >> > >> > >> > tom |
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.