Countif absolute reference

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
 
J

Jim Rech

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.
 
D

Don Guillett

Unlike some function such as sumproduct, countif will work with entire
columns, if desired. Not recommended.
=countif(a:a,whatever)
 
Top