Thread: A report macro
View Single Post
  #2   Report Post  
tina
 
Posts: n/a
Default

Hi
I think you want to use the countif and count functions
eg
=countif(a1:a10,true)&" out of " &count("a1:a10")
you may have to replace count with counta if text fields

Tina
"Jocke" wrote:

How do I do to get a report of how many cells that fufill an argument? For
instance I have 10 cells 7 of them fulfill my argument how do I do to get the
answer 7 out of 10 or something similar?