COUNTIF with Logic?
Just checking you were paying attention <vbg
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Leonhardtk" wrote in message
...
Perfect (except the first Parenthesis, which is backwards). Exactly what
I
was looking for.
KSL
"Bob Phillips" wrote:
=SUMPRODUCT)--('Doc Log'!B2:B126=STATS!B3),--('Doc
Log'!C2:C126="Delivered"))
etc.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Leonhardtk" wrote in message
...
I have a statement (below) that works fine for finding all instances
where
a
person performed a task:
=COUNTIF('Doc Log'!B2:B126,STATS!B3)
(B2-B126 is where I'd find the person's name, and STATS!B3 is their
name
from a summary table) I want to add a statement so that I'd only
count
their
name if, say C2:C126 has the value "Delivered" in it for that same
line.
For example if the first three lines we
A1 B1 C1
1 Jan 06 | Smith|Delivered
1 Jan 06 | Simms|Reviewed
1 Jan 06 | Smith| Reviewed
1 Jan 06 | Smith| Delivered
I need two statements for Smith
COUNTIF "SMITH" and "Delivered" (SMITH and Delivered must be on same
row!)
COUNTIF "SMITH" and "Reviewed"
In the example above, I also need to do
COUNTIF "Simms" and "Reviewed" etc.
Appreciate any help anyone might be able to provide!
KSL
|