In the first column type the formula:-

=If(C1<6,C1,0)

and in the next column

=if(C16,C1,0)

Assuming the totals are in column C


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=502532