Thread: IF,And,OR Help
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade
 
Posts: n/a
Default IF,And,OR Help

=IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress",
AE9="EXPU"))),1,0)

And whereever you have total count, just do a =SUM()


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550065

Reply With QuoteReply With Quote