Re: More than 1 countif criteria

Giganews Newsgroups
Subject: Re: More than 1 countif criteria
Posted by:  Bob Phillips (bob.N…@googlemailxxx.com)
Date: Tue, 2 May 2006

=SUMPRODUCT(--(A2:A200=10032),--(B2:B200=--"2006-04-03"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"KristyBT" <Kristy…@discussions.microsoft.com> wrote in message
news:7FE9C48F-93AF-42EB-8CFF-F050D2754B…@microsoft.com...
> I have the following data that I'm trying to do a countif on.  What I need
is
> to enter a formula that will count how many times 10032 was entered on
> 4/3/2006.
>
> I have looked at other posts with more than 1 countif criteria but I
haven't
> had any luck.  Please help!
>
> ColumnA    ColumnB  ColumnC
> Vendor      Date        Salesman
> 10032 4/3/2006 DAMON
> 10032 4/3/2006 DAMON
> 10032 4/3/2006 DAMON
> 10032 4/3/2006 DAMON
> 10032 4/3/2006 DAMON
> 10032 4/3/2006 EVERETT
> 10032 4/3/2006 EVERETT
> 10032 4/3/2006 EVERETT
> 10032 4/3/2006 EVERETT
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 10032 4/3/2006 YVETTE
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA
> 2619 4/3/2006 LYDIA

Replies

None

In response to

More than 1 countif criteria posted by KristyBT on Tue, 2 May 2006