Count of Report values in Report Footer

Hi
I need to create a count at the end of my report that tells me how many
occurances of a certain value appear in the report.
e.g. Report field of "Issue". Possible values of "Red" or "Amber". Need to
count how many times red and amber occurs.
I guess, something like "COUNT(Issue) where Issue = "Red")" is needed.
e.g. 2 (more complex)
e.g. Report field of "Name". I do not want to "hard code" the possible
values that can appear in the report for Name but I need to count how many
times each name appears in the report.
I have played around with SUM and COUNT and tried the Running Sum function
but to no avail.
Any help much appreciated.
Thanks, Mark