Hi,

I have a spreadsheet of all attendees of past events. I now have to add to
it anyone who has registered for an event (but did not show up). I am
differentiating between these in column Z - all those who registered but did
not show up have a "R" marked; attendees are left blank. If my original
formula is: =COUNTIF('Full list'!D:D,3), how do I add to it now to only
COUNTIF if there IS NOT a "R" marked in column Z?

Thanks so much.