ExcelBanter - A report macro

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - A report macro (https://www.excelbanter.com/new-users-excel/22780-report-macro.html)

Jocke

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?

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
"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?

All times are GMT +1. The time now is 11:54 AM.