Thread: [Solved] searching a range using a value in another cell
View Single Post
 
Old 05-11-2015, 03:01 PM
beginner beginner is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default
Quote:
Originally Posted by derohanes View Post
It doesn't like this command. When I select "OK", it highlights "$C$6". (Please see attached image)
Replace the semicolon with a comma
Code:
=COUNTIF(Sheet1!$B$2:$C$6,"*"&A2&"*")
Please you see atachment
Attached Files
File Type: xlsx Formulae.xlsx (11.5 KB, 8 views)
Reply With Quote