Jennifer?? Jennifer was not invited to the party.

Which column does Jennifer appear in? 1st, 2nd? 3rd?

=SUMPRODUCT(--(K2:K16="Brian"),--(L2:L16="closed"),--(M2:M16="Brian"))
works for me to total up the rows where Brian was assigned, the issue is
closed and Brian was the closer. Spelling and capitalization count. Change
16s to 1669 in your formula.

"Dot" wrote:

Okay I just found a flaw, turns out its counting the information twice for
two different people. Below is how the columns are set up and the functions
I'm using
Assigned Status Reassigned
Sandra Closed
Sandra
Sandra Closed
Sandra Closed
Sandra Closed brian
Sandra
Sandra Closed
Sandra Closed
Sandra Closed
Sandra Closed brian
Sandra Closed brian
Sandra Closed
Sandra
Sandra Closed
Sandra Closed Christine

Brian took over some of the assigned tasks that were given to Sandra but it
is counting them for both employees. Here is the new function I added, it
worked for one person but then put a N/A value on another:

=SUMPRODUCT((Assignments!K2:M1669="Brian")*(Assign ments!L2:L1669="closed")*(Assignments!M2:M669="Bri an"))

On Brian it is now giving me the #N/A value where on Jennifer it worked.
--
Dot


"Don Guillett" wrote:

Glad to help

--
Don Guillett
SalesAid Software

"Dot" wrote in message
...
That worked!!! Thanks so much Don I've been working on this all day and
it's
been driving me crazy :-)
--
Dot


"Don Guillett" wrote:

this maybe
=sumproduct((Assignments!K2:M1669="Brian")*(Assign ments!
n2:n1669="closed"))

--
Don Guillett
SalesAid Software

"Dot" wrote in message
...
I'm trying to bring three columns together that checks for a condition
of
a
persons name and counts how many items were processed. I have the
first
function =COUNTIF(Assignments!K2:M1669,"Brian") that's working but I
don't
want it to include the blank cells only cells that have "closed". What
information am I missing? I tried including the nested argument If but
keep
getting a value error.
--
Dot