View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Robert is offline
external usenet poster
 
Posts: 193
Default Counting text in two different columns

I'm trying to create a formula to count text in two different columns for
instance:

Samle work sheet:

A B
Jon apples
Jo apples
Jon grapes
Jon apples
Jo apples
Jon oranges
Eric apples
Jo apples

I want a formula that would show me how many "apples" Jon has. Please help!
Thanks