| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SumProduct or CountIf
I am trying to implement the following function to count the number of
entries I have for January, February, etc. =SUMPRODUCT(--(TEXT(SheetName!J5:J8,"mmmm")="January")) It works fine for February, March, etc. but not for January because it reads the empty cells as being 01/01/1901. Any suggestions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif, sumproduct | New Users to Excel | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
| SUMPRODUCT & COUNTIF | Excel Worksheet Functions | |||
Threaded Mode
