Count

[Stuart]

I need to count the number of text entries in each column
of a cross tab report a list, where the value in a
neighbouring row matches a given value.

So, the report shows all the sites for which each Regional
Manager is responsible (rows) and who is planned to man
the site each day (columns).

I want a summary at the base of each day's column, showing
the number of people planned for each region on that day.

I know it doesn't exist but I'm thinking of this as
COUNTAIF(range,criteria,sum_range), similar to SUMIF.

Any ideas?

 

[Frank Kabel]

Hi
use COUNTIF
for this