A report macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top