Thread: HOW DO I ADD ROWS WITH TWO TEXT VARIABLE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Phil Phil is offline
external usenet poster
  
Posts: 31
Default HOW DO I ADD ROWS WITH TWO TEXT VARIABLE
Hi BabyBlue,

If you just want to see how many times a certain word appears in each
column, try

=COUNTIF(C3:C33),"your word")+COUNTIF(H3:H33,"your word")

Hope that helps,

Phil
Reply With QuoteReply With Quote