COUNTIF formula

  • Thread starter Thread starter Sabrina
  • Start date Start date
S

Sabrina

How do you keep the COUNTIF formula from changing the
range of cells, when you copy and paste it to count
another item? (example: b2:t45 changes to b3:t46).
 
How do you keep the COUNTIF formula from changing the
range of cells, when you copy and paste it to count
another item? (example: b2:t45 changes to b3:t46).
Click to expand...

Read the online help topic titled 'About cell and range references'. You need to
use a row-absolute range reference.
 
Back
Top