A report macro

[Jocke]

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?

 

[tina]

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