CountIF (1 Viewer)

[Number11]

how do i copy this formula to all rows

=COUNTIF(A:A,A112911)

if i drag it it changed the row number

=COUNTIF(A:A,A112912)
=COUNTIF(A:A,A112913)
=COUNTIF(A:A,A112914)
=COUNTIF(A:A,A112915)


and so on..

 

[Josef P.]

This will be difficult in an Access query (used forum: Microsoft Access Discussion -> Queries).

In Excel:
=COUNTIF(A:A,A$112911)
... or simply refer to the top line in the subsequent lines, as it will always be the same value.

 

[Gasman]

how do i copy this formula to all rows

=COUNTIF(A:A,A112911)

if i drag it it changed the row number

=COUNTIF(A:A,A112912)
=COUNTIF(A:A,A112913)
=COUNTIF(A:A,A112914)
=COUNTIF(A:A,A112915)


and so on..

Why would you want the same value in every cell?

 

[Minty]

Why would you want the same value in every cell?

It could be a constant value, like a VAT rate or similar set in one place in the sheet?

 

[Gasman]

It could be a constant value, like a VAT rate or similar set in one place in the sheet?

Ah, I just refer to that one cell each time.
I would use CountIf() to count the various items in my rows/columns.

Like so

Title	Count
Mr	72​
Mrs	184​
Ms	1​
Miss	3​