View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hilvert Scheper Hilvert Scheper is offline
external usenet poster
 
Posts: 31
Default Countif against a range of text entries

Hi there,
I can't seem to find an answer here to the following problem:

I have a Range of 15 Cells with Text,
is there a way do do a "Countif" (or something similar) in a column in
another File against All of these 15 Cells in just one formula?
If I add the Countifs for all 15 cells, the formula is half a mile long and
cannot be copied.

Any help here is Very Welcome,
Many Thanks in advance!!

Rgds,
Hilvert Scheper