COUNT IF
 

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.

COUNT IF
 

Maybe something like these:

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="yes"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="no"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range=""))

--
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.

COUNT IF
 

CAN I EMAIL YOU MY WORKSHEET?

"T. Valko" wrote:

Maybe something like these:

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="yes"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="no"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range=""))

--
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.

COUNT IF
 

Turn off your caps lock key!

If those don't work then try explaining in greater detail.

--
Biff
Microsoft Excel MVP


"DUB" wrote in message
...
CAN I EMAIL YOU MY WORKSHEET?

"T. Valko" wrote:

Maybe something like these:

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="yes"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range="no"))

=SUMPRODUCT(--(salesman_range="salesman_name"),--(rsvp_range=""))

--
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.