Use COUNTIF instead of DCOUNT

=COUNTIF(D2:D2000,1)


"Engels" wrote:


I am trying to implement a count function to count the number of instances
of the number 1 in the column "Venue"

I believe this requires the use of a DCount function but i am having trouble
implementing it.

could somebody hepl and provide an example of how to do it that i can copy
and alter. I basically want to count the instances of the number 1 in cells
D2 through to D2000)