| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with countif function
Hi,
I am trying to produce a count from the following sample data (actual data over 2000 rows!)..driving me nuts..tried countif but not sure how to implement it because of dates and multiple criteria Region Date North 01/01/05 South 04/05/06 West East 09/04/01 North 04/03/04 South 11/01/03 West 15/03/01 East North 14/12/04 Total by date North 3 South 2 East 1 West 1 I can this can be done in a pivot table but I need a worksheet function (trust me...if easier for a colleague!) Can someone help? Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AND function using COUNTIF | Excel Worksheet Functions | |||
| Need help with Countif function | Excel Worksheet Functions | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
Threaded Mode
