How to keep a set range in a Search function

C

Connie

I am using the following function to look at numerous worksheets and count
how many times a certain number shows up:

=SUMPRODUCT(--ISNUMBER(SEARCH(A2,'Site #02-Maine Medical Center'!G2:G42)))

However, when I try to copy the function in the next cell, it always changes
my search range (ex. G2:G42 goes to G3:G43). How do I keep the range from
increasing? I always want to search this range for this particular
spreadsheet.
 
G

Glenn

Connie said:
I am using the following function to look at numerous worksheets and count
how many times a certain number shows up:

=SUMPRODUCT(--ISNUMBER(SEARCH(A2,'Site #02-Maine Medical Center'!G2:G42)))

However, when I try to copy the function in the next cell, it always changes
my search range (ex. G2:G42 goes to G3:G43). How do I keep the range from
increasing? I always want to search this range for this particular
spreadsheet.
Click to expand...

Change to absolute references.

$G$2:$G$42
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a range in a named range 3
How to center adjust text above and image in a two column document. 1
Search for either one or the other 4
Search for value in a range 6
How to search a SS for values greater-than? 0
Function to seacrh for a word across multiple columns 2
Build search function in to a form 5
IF function that searches a range of cells for data and provide tr 2

Top