I need a formula to tally a list of birds that are seen by my birding club. It is a little more complicated than just addding totals of columns.
For example:
Here is the monkey wrench.
In 2010 we saw 100 birds = 100 birds
In 2011 we saw 100 birds but 20 of the birds were different from the birds we saw in 2010 so the total number of new birds for both years seen is 120 birds
In 2012 we saw 90 birds but 10 of those were entirely different from the birds we saw in either 2010 or 2011, so the running total is now 130 birds.
So I need a running total of the number of different kinds of birds that were seen over the years.
The left side of the spread sheet I have all the birds listed and the top has the last 10 years for which we have been collecting stats (which needs to be added to in future years)
The right side of the spread sheet shows a total of how many years the individual bird has been seen and the bottom row will be a total of how many birds were seen that particular year. The data has not been entered as yet, so changes can easily be made if necessary.
Figuring out that Grand Grand total has stumped everyone I have asked.
Anyone up for the challenge??? It would be a valuable statistic for our club.
Thanks,
The Owl Lady
Bookmarks