If you're asking for the most frquently occurring number in column C
when column A is "sales" and column B is s682, i.e. the answer is 4 in
your example then you can use this formula

=MODE(IF((A1:A10="sales")*(B1:B10="s682"),C1:C10))

confirmed with CTRL+SHIFT+ENTER

adjust ranges as necessary


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=542198