DCount help
=COUNTBLANK(D2:D2000)
"Engels" wrote:
That works great thanks can you now help me with a complication.
I want to do the follwing using the COUNTBLANK function: I'll write it as
logically as i can:
Count Blank Cells in D2:Dxxx
Where Dxxx = same row as first blank in A2:A2000
in other words i want to count the number of blank fields in the column but
i don't know how many records i will have each time the formula is used the
entry in column A will confirm if there is a record or not (it's a required
field)
"Teethless mama" wrote:
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)
|