Copying and pasting the COUNTIF formula

[Sabrina]

How do you copy the COUNTIF formula when you want to count
various items and still keep the cell range the same?
Everytime I cut and paste the formula, it changes the cell
range (example - b2:t45 changes to b3:t46). How do I make
the formula static?

 

[Peo Sjoblom]

Select the cell, in the formula bar select the range and press F4, or type
manually $B$2:$T$45

 

[Frank Kabel]

Hi Sabrina
you have to use absolut references (indicated by the $ sign). So change
B2:T45
to
$B$2:$T$45
now the reference won't change anymore
Frank

 

[Norman Harker]

Hi Sabrina!

Use the following:
=COUNTIF($B$2:$T$45,D28)

You just make the range an absolute reference.

Easiest way to do this is to select the cells in your formula and bang
the F4 key. Or use the F4 key when entering the range.

Take a look at:
Chip Pearson:
http://www.cpearson.com/excel/relative.htm
Introduction to cell referencing concepts.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.