More than 1 countif criteria
 

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

More than 1 countif criteria
 

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"KristyBT" wrote in message
...
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

More than 1 countif criteria
 

Hi

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

Roger Govier


"KristyBT" wrote in message
...
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