View Single Post
  #1   Report Post  
Puzzler
 
Posts: n/a
Default Why cant I use =countif(Jan:Mar!$b3)

=sum(Jan:Mar!$b3) works fine. Why can't I use this same 3d reference with
the countif option. The values in the cells are all numbers - but I receive a
#value error.