You can also use =Count(range) and it will count any cell that has something in it and it does not have to a number.
Pat Sent from my mobile phone. On Dec 25, 2010, at 8:04 AM, "dan&erika" <daner...@gmail.com> wrote: > Dave's solution works well. Instead of X, I use the number 1. Then, at the > bottom of the column I insert the formula =sum(F1:F600) to cover the length > of the column. > > I once used a bird listing program. It lasted about two days before it > crashed and I lost all my data. Excel files are much better. > > You can download an excel bird list from my website: > http://dantallmansbirdblog.blogspot.com > > Merry Christmas > > dan > > On Sat, Dec 25, 2010 at 7:50 AM, David Bergum <d...@mac.com> wrote: > >> Mike, you can use the countif function. In the cell where you want your >> total bird count, put: >> >> =countif(F1:F600,*) >> >> Where F1:F600 is the column range where you have some character, like "x" >> if you saw the bird. All you have to do in the seen birds is put some non >> empty string to get it counted. >> >> Dave >> >> On Dec 25, 2010, at 0:21, Michael Hendrickson wrote: >> >>> Hello: >>> >>> I am I just downloaded a complete list of birds of United States into >> Excel. I >>> was wondering if anyone knows how to create a list on excel so that if I >> add a >>> "X" or color in that cell next to that bird species there will be a >> number >>> telling me how many birds I seen for United States, Minnesota and St. >> Louis >>> County. I created columns for each of those items. I am a little >> puzzled on >>> how to the rest. I know there are birders who created their own excel >> bird >>> lists and I would be interested in hearing from those that have done so >> and if >>> they can give me some help to create the list. I know it would easier to >> buy >>> some bird listing program but I rather not or use some external listing >> program >>> out there but I prefer to learn to use excel in creating bird lists. >>> >>> Thanks so much >>> >>> Merry Christmas to all >>> >>> Mike >>> >>> >>> Mike Hendrickson >>> Duluth, Minnesota >>> Website: http://www.mikehendricksonbirding.com >>> >>> Blog: http://colderbythelakebirding.blogspot.com/ >>> >>> >>> >>> >>> ---- >>> Join or Leave mou-net: http://lists.umn.edu/cgi-bin/wa?SUBED1=mou-net >>> Archives: http://lists.umn.edu/archives/mou-net.html >>> >> >> David Bergum <d...@mac.com> >> [1282 Wander Rd, Isabella, MN] 218-365-0887 >> POBox 696 218-206-2133 Skype >> Ely, MN 55731 612-723-7135 Mobile >> >> ---- >> Join or Leave mou-net: http://lists.umn.edu/cgi-bin/wa?SUBED1=mou-net >> Archives: http://lists.umn.edu/archives/mou-net.html >> > > > > -- > Dan or Erika Tallman > Northfield, Minnesota > http://sites.google.com/site/tallmanorum > http://dantallmansbirdblog.blogspot.com > http://picasaweb.google.com/danerika > daner...@gmail.com > > ".... the best shod travel with wet feet" > "Beware of all enterprises that require new clothes ...."--Thoreau > > ---- > Join or Leave mou-net: http://lists.umn.edu/cgi-bin/wa?SUBED1=mou-net > Archives: http://lists.umn.edu/archives/mou-net.html > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ ---- Join or Leave mou-net: http://lists.umn.edu/cgi-bin/wa?SUBED1=mou-net Archives: http://lists.umn.edu/archives/mou-net.html