=SUMPRODUCT(COUNTIF(INDIRECT({"D5","D8","D11","G5" ,"G8","G11","J5","J8","J11
"}),1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jp" wrote in message
...
I need to count all the nonconsecutive cells in a given range that contain
a
specific # 1-9. I have a formula that counts all the cells in the given
range: =countif(c4:k12,"1"). I need to modify it to count only the cells
d5,d8,d11,g5,g8,g11,j5,j8,j11 that contain the #1. I know there must be a
way
but i am not familure enough with creating formulas to figure it out.
Please
help. I am using excel 2002. jp