How do t get a cell to count it's self as .5?

plantman · May 9, 2004

how do make a cell count it's self as 1/2 or .5 as when i use the count if function it always count as 1

Ron Rosenfeld · May 9, 2004

how do make a cell count it's self as 1/2 or .5 as when i use the count if function it always count as 1

=COUNTIF(A:A,"criteria")/2

--ron