The easiest method is to use a pivot table. Next to that, a filter
method would work. Otherwise, a macro could delete data from the tally
sheet and add what you wanted then.

For the last 2 methods using =countif, you would use it like this:
=COUNTIF(A:A,A1)


--
Kenneth Hobson
------------------------------------------------------------------------
Kenneth Hobson's Profile: http://www.thecodecage.com/forumz/member.php?userid=413
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105852