Re: More than 1 countif criteria

Giganews Newsgroups
Subject: Re: More than 1 countif criteria
Posted by:  Roger Govier (rog…@technologyNOSPAM4u.co.uk)
Date: Tue, 2 May 2006

Hi

Try
=SUMPRODUCT(--($A$1:$A$1000=1032),--($B$1:$B$1000=date(2006,4,3)))
Change ranges to suit

--
Regards

Roger Govier

"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