For 1-10

=sumif(am15:am830,"<11",d15:d30)

or for 11-17

=sumif(am15:am830,"10",d15:d30)-sumif(am15:am830,"17",d15:d30)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515078