I have a report which lists weather or not someone has attended an event simply by haveing a Y or N next to that event. I need to have a total at the bottom of the report which counts only the "Y"'s. Anyone know how. I tried =IIF([Present]="Y",Count([Present])) but that didnt work.