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 <[email protected]> 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 <[email protected]> > [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 [email protected] ".... 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
