Hello,

I have a bird watching record saved as an excel file. Now I would like
to analyze this file.

There are columns: Date, Name of the Bird and Quantity.

Many dates have same birds.

I would like to calculate how many birds of certain type I have seen.

Im trying to figure out the formula to do this for me.

I know that I should first compare Name of the Bird cells and pick all
the rows that has certain value (for example a Bohemian Waxwing). Then
I should calculate together all Quantities for these rows.

What would be the easiest formula to do this?

Heres an short example of the sheet and the results Im hoping to get

Date Bird Qty

05/06/06 A Fishing Eagle 1
05/06/06 A Marsh Harrier 1
05/06/07 A Hen Harrier 2
05/06/07 A Marsh Harrier 3
05/06/08 A Fishing Eagle 2


Results:

Year 2005 all together:

A Fishing Eagle 3
A Marsh Harrier 4
A Hen Harrier 2


---

The question: How can I limit my calculation for certain birds?

Thanks in advance!


--
Petri M
------------------------------------------------------------------------
Petri M's Profile: http://www.excelforum.com/member.php...o&userid=29210
View this thread: http://www.excelforum.com/showthread...hreadid=489386