Thread: how i can count the dicontineued lines according to category wise
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default how i can count the dicontineued lines according to category wise
Hmm, perhaps:
=COUNTIF(A1:A7000,"+")+COUNTIF(A1:A7000,"-")+COUNTIF(A1:A7000,"")
Reply With QuoteReply With Quote