COUNTIF with Logic?

[Leonhardtk]

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 were:

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

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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 were:
>
> 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

[Leonhardtk]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 were:
> >
> > 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
>
>
>

[Bob Phillips]

Just checking you were paying attention <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Leonhardtk" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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 were:
> > >
> > > 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
> >
> >
> >