View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default countif only when an exact match occurs

I have a column of data that contains text values such as "Branch" and
"Branch Remote". I need to count the occurrances for each but my Branch
count is including Branch Remote. The countif statements are

=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch*" )

=COUNTIF('1208ATMDispatches'!$B$10:$B$63,"Branch Remote*")

I am using the * because the source data has a space after Branch and also
after Branch Remote.

How can I do an exact match using the countif statement.

Any help would be appreciated.

Thanks,

Mike