Instead of using a wildcard why not just include the space?

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

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


--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
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