see your other post

--
Biff
Microsoft Excel MVP


"DUB" wrote in message
...
I HAVE A DATABASE OF INVITES FOR A CORPORATE FUNCTION. ON A SEPERATE
WORKSHEET I WAS ABLE TO DO A COUNTIF SO I KNOW HOW MANY INVITES A SALESMEN
REQUESTED TO BE SENT. WHAT I NEED HELP WITH IS: A COUNT OF HOW MANY
"YES"
RSVP'S A SALESMAN RECEIVED AND A COUNT OF HOW MANY "NO" RSVP'S AND A COUNT
OF
HOW MANY RSVP'S ARE BLANK.