actually yes, but the count criteria will be based on the status which
can be "op"

or "workshop". I am not sure whether to use countif or sumproduct. pls
advise.


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=479353