use the sumproduct function to count only those criteria you are
interested in - thus by certain teams only, certain dates only, certain
criteria only - you can even have a drop down list or lists that allow
you to analyse your data.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=561139