Thanks Don, I tried that as well as still getting a different answer. Here
is the scenario, I have 19 employees that are assigned tasks for the day of
applying cash and when they are finished with their work they go and help
their team mates. Take Brian for example, he was originally assigned 75
checks, of those checks he completed 55 then he went to another team member
and closed 24 of theirs. So on his original assignments he won't be putting
anything in the reassigned column but would be marking the items as closed,
so when I use the first set of function
=sumproduct((Assignments!K2:K1669="Brian")*(Assign ments!L2:L1669="Closed) i
get the correct answer of 55, but the minute I add in
*(Assignments!M2:M1669="Brian")) it only shows 55 as it's not taking into
account the additional 24 he picked up, since they were originally assigned
to Sandy it is counting them in her numbers. If I change the first part of
the function to Assignments!K2:M1669="Brian")) then it gives me a figure of
134 which is adding the K column twice but also picking up the M column. I
have tried changing the operand of * to a minus/plus sign but that doesn't
work either. I thought maybe since I was doing this on another spread sheet
and bring the information in is why it was causing the issue but that is not
the case as I get the same information if I put on the same spread sheet as
where the data is being housed.

Your thoughts?
--
Dot


"Don Guillett" wrote:

I just tested this using
=SUMPRODUCT((K2:K16="B")*(L2:L16="C")*(M2:M16="B") )
b c b
b c b
b c c
b b b

For the above, I get 2. It will be true only if you get b,c,b on the same
row.
Send me your wb, if desired along with a complete explanation and what
errrors
And, for the info given below, I get 3 for Sandra,Closed,Brian
Capitalization does NOT matter.

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


..
--
Don Guillett
SalesAid Software

"Dot" wrote in message
...
Sorry Don,
Column K=Assigned, L=Status, M=Reassigned

I have 1700 lines that I'm working with and 18 employees, when I use the
below function the count no longer works but if I take off the last part
of
the function it works but not correctly for everyone:

=SUMPRODUCT((Assignments!K2:K1669="Brian")*(Assign ments!L2:L1669="Closed")*(Assignments!M2:M1669="Br ian"))

I made sure everyone starts with a capital letter on their name as well as
the status closed starting with a capital letter.

--
Dot


"Don Guillett" wrote:

I'm confused about your layout.... Your example gives TWO columns.

--
Don Guillett
SalesAid Software

"Dot" wrote in message
...
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