software

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 quot;Deliveredquot; 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 quot;SMITHquot; and quot;Deliveredquot; (SMITH and Delivered must be on same row!)
COUNTIF quot;SMITHquot; and quot;Reviewedquot;
In the example above, I also need to do
COUNTIF quot;Simmsquot; and quot;Reviewedquot; etc.

Appreciate any help anyone might be able to provide!

KSL

=SUMPRODUCT)--('Doc Log'!B2:B126=STATS!B3),--('Doc
Log'!C2:C126=quot;Deliveredquot;))

etc.--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Leonhardtkquot; gt; wrote in message
...
gt; I have a statement (below) that works fine for finding all instances where
a
gt; person performed a task:
gt;
gt; =COUNTIF('Doc Log'!B2:B126,STATS!B3)
gt;
gt; (B2-B126 is where I'd find the person's name, and STATS!B3 is their name
gt; from a summary table) I want to add a statement so that I'd only count
their
gt; name if, say C2:C126 has the value quot;Deliveredquot; in it for that same line.
gt; For example if the first three lines we
gt;
gt; A1 B1 C1
gt; 1 Jan 06 | Smith|Delivered
gt; 1 Jan 06 | Simms|Reviewed
gt; 1 Jan 06 | Smith| Reviewed
gt; 1 Jan 06 | Smith| Delivered
gt;
gt; I need two statements for Smith
gt; COUNTIF quot;SMITHquot; and quot;Deliveredquot; (SMITH and Delivered must be on same row!)
gt; COUNTIF quot;SMITHquot; and quot;Reviewedquot;
gt; In the example above, I also need to do
gt; COUNTIF quot;Simmsquot; and quot;Reviewedquot; etc.
gt;
gt; Appreciate any help anyone might be able to provide!
gt;
gt; KSL
Perfect (except the first Parenthesis, which is backwards). Exactly what I
was looking for.

KSL

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT)--('Doc Log'!B2:B126=STATS!B3),--('Doc
gt; Log'!C2:C126=quot;Deliveredquot;))
gt;
gt; etc.
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Leonhardtkquot; gt; wrote in message
gt; ...
gt; gt; I have a statement (below) that works fine for finding all instances where
gt; a
gt; gt; person performed a task:
gt; gt;
gt; gt; =COUNTIF('Doc Log'!B2:B126,STATS!B3)
gt; gt;
gt; gt; (B2-B126 is where I'd find the person's name, and STATS!B3 is their name
gt; gt; from a summary table) I want to add a statement so that I'd only count
gt; their
gt; gt; name if, say C2:C126 has the value quot;Deliveredquot; in it for that same line.
gt; gt; For example if the first three lines we
gt; gt;
gt; gt; A1 B1 C1
gt; gt; 1 Jan 06 | Smith|Delivered
gt; gt; 1 Jan 06 | Simms|Reviewed
gt; gt; 1 Jan 06 | Smith| Reviewed
gt; gt; 1 Jan 06 | Smith| Delivered
gt; gt;
gt; gt; I need two statements for Smith
gt; gt; COUNTIF quot;SMITHquot; and quot;Deliveredquot; (SMITH and Delivered must be on same row!)
gt; gt; COUNTIF quot;SMITHquot; and quot;Reviewedquot;
gt; gt; In the example above, I also need to do
gt; gt; COUNTIF quot;Simmsquot; and quot;Reviewedquot; etc.
gt; gt;
gt; gt; Appreciate any help anyone might be able to provide!
gt; gt;
gt; gt; KSL
gt;
gt;
gt;

Just checking you were paying attention lt;vbggt;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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