A report macro

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?

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?