| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF date formula
Hello,
I have a column of dates in dd/mm/yyyy format, and I need to add up the total number of instances in a given month. I have been trying to use a COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other configurations of this, and cannot get it to work, does anyone have any suggestions? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF date formula
Try something like this:
=SUMPRODUCT(--(TEXT(A1:A50,"yyyymm")="200801")) Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "suek" wrote in message ... Hello, I have a column of dates in dd/mm/yyyy format, and I need to add up the total number of instances in a given month. I have been trying to use a COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other configurations of this, and cannot get it to work, does anyone have any suggestions? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF date formula
It works splendiferously! Thanks!
"Ron Coderre" wrote: Try something like this: =SUMPRODUCT(--(TEXT(A1:A50,"yyyymm")="200801")) Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "suek" wrote in message ... Hello, I have a column of dates in dd/mm/yyyy format, and I need to add up the total number of instances in a given month. I have been trying to use a COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other configurations of this, and cannot get it to work, does anyone have any suggestions? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF date formula
You're very welcome......I'm glad I could help.
-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "suek" wrote in message ... It works splendiferously! Thanks! "Ron Coderre" wrote: Try something like this: =SUMPRODUCT(--(TEXT(A1:A50,"yyyymm")="200801")) Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "suek" wrote in message ... Hello, I have a column of dates in dd/mm/yyyy format, and I need to add up the total number of instances in a given month. I have been trying to use a COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other configurations of this, and cannot get it to work, does anyone have any suggestions? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif only col a = col b by date | Excel Worksheet Functions | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| CountIf by Month-to-date | Excel Worksheet Functions | |||
| countif date | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Linear Mode
