Say the number of trucks is in B1 to B9. The following formula entered in any
unused cell will do what you want.

=COUNTIF(B1:B9,5)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1