COUNTIF formula

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).
 
H

Harlan Grove

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.
 

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

Copying and pasting the COUNTIF formula 3
Countif for different values 12
Countif Question 4
countif 3
Can you use an INDEX array in a COUNTIF formula ? 1
simple countif formula 2
Sumproduct not working 5
How to count a coloum if two conditions are met 5

Top