Count If

[=?iso-8859-1?B?QW5kcuk=?=]

How can i do a Countif to cover a column from A3 to
wherever the last cell with the data i'm looking for is in?

A.

 

[Peo Sjoblom]

One way

=COUNTIF(OFFSET($A$3,,,COUNTA(A3:A65536)),Criteria)

 

[Chris Leonard]

another way

=countif(A:A,criteria)

One way

=COUNTIF(OFFSET($A$3,,,COUNTA(A3:A65536)),Criteria)

--

Regards,

Peo Sjoblom

 

[Bob Phillips]

Chris,

If A1 and/or A2 also have that value in them, you get the wrong result with
your formula, but not Peo's.

Maybe unlikely, but that was what Peo was guarding against. Unfortunately
Peo's version fails to take blank rows into account. Here's another option
which covers both of these possibilities

=SUMPRODUCT(--(A3:A65536="Data 1"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

Or

=COUNTIF(A3:A65536,Criteria)