Hi

Try
=COUNTIF(D2:D2000,1)

--
Regards

Roger Govier


"Engels" wrote in message
...

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)