| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can countif function look at 2 separate columns for criteria | Excel Worksheet Functions | |||
| COUNTIF with two criteria | Excel Worksheet Functions | |||
| countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
