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
