Countif absolute reference

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

how can i select the countif to check the whole column for data as
opposed to just one cell, thought i read somewhere the i should use the
F4 key to make it absolute.

However this just makes that one cell absolute i need the whole column
 
You can use Countif on a range like this:

=COUNTIF(A1:A10,"a")

You can make it an absolute reference like this:

=COUNTIF($A$1:$A$10,"a")

but that does not change how the formula works, only how the referenced
range changes when you copy/paste the cell it's in.
 
Unlike some function such as sumproduct, countif will work with entire
columns, if desired. Not recommended.
=countif(a:a,whatever)
 

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

Formula autofill to cells below – formula arguments are cell areas in different columns 1
Excel Need Countifs Formula Help 0
Absolute and Relative Cell References 1
Absolute References 3
Change relative to absolute references in a block of cells 3
Countif formula 2
Making multiple cells absolute at once 1
Reference changes when I insert new columns in the source sheet 3

Back
Top