Hi - sounds like you just need a simple subtraction:

=COUNTIF('Full list'!D:D,3) - COUNTIF('Full list'!Z:Z,"R")

If the data is not as simple as that, you could use a SUMPRODUCT formula:

=SUMPRODUCT(('Full list'!D:D=3)*('Full list'!Z:Z<"R"))

HTH
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


"h20polo" wrote:

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.