Sorry about that it should have been: =CountA(range) I just did it with "X" and it counted all the cells that had an X
Pay Sent from my mobile phone. On Dec 25, 2010, at 11:54 AM, "Rick Hoyme" <[email protected]> wrote: > COUNT(Range) only counts numbers in excel. I just tried it to confirm. > > -----Original Message----- > From: Minnesota Birds [mailto:[email protected]] On Behalf Of Patrick > Clements > Sent: Saturday, December 25, 2010 11:07 AM > To: [email protected] > Subject: Re: [mou-net] Making a Bird List Question > > 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" <[email protected]> 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 <[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 >> >> ______________________________________________________________________ >> 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 > > ---- > 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
