Hi

this will be =SUMIF ( Range of All Birds, A Bird Name, Qty of bird
range)

See below

06-May black 3
06-May brown 2
06-May red 1
08-May black 0
08-May white 7
08-May brown 6
08-May red 2
08-May green 4
10-May black 6
10-May white 3
10-May brown 5
10-May red 2
10-May green 4

` = SUMIF($B$5:B18,$H5,$D$5:$D$18) ----This is the formula when
written


black 9
white 45
brown 13
red 5
green 8


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