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

=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

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

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