Mike Hendrickson wrote:
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 know it would easier to buy
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
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
To: MOU-NET@LISTS.UMN.EDU
Subject: [mou-net] Making a Bird List Question
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
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, danerika daner...@gmail.com wrote:
Dave's solution works well. Instead of X, I use the number 1. Then, at the
Wings works really well for Macs and Windows:
http://web.mac.com/wings_4d/Wings/Welcome.html
Back in the 90s I made this really detailed spreadsheet for a birding trip to
Belize, with nice colors and sub totals and daily counts. Somehow, going from
machine to machine, I lost it. Really
COUNT(Range) only counts numbers in excel. I just tried it to confirm.
-Original Message-
From: Minnesota Birds [mailto:mou-...@lists.umn.edu] On Behalf Of Patrick
Clements
Sent: Saturday, December 25, 2010 11:07 AM
To: MOU-NET@LISTS.UMN.EDU
Subject: Re: [mou-net] Making a Bird List
.
-Original Message-
From: Minnesota Birds [mailto:mou-...@lists.umn.edu] On Behalf Of Patrick
Clements
Sent: Saturday, December 25, 2010 11:07 AM
To: MOU-NET@LISTS.UMN.EDU
Subject: Re: [mou-net] Making a Bird List Question
You can also use =Count(range) and it will count any cell
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,
9 matches
Mail list logo