ExcelBanter - View Single Post

Don Guillett

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