Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs and wildcards to count dates
Hi!
I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year. here the formula: =countifs(...;[range];"=*"&month(A4)&"/"&year(A4);...) this formula returns 0. If I change the wildcard with a specific day number, it works fine. Any clue? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs and wildcards to count dates
Hi,
Am Fri, 2 Oct 2015 00:38:42 -0700 (PDT) schrieb : I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year. better use SUMPRODUCT: =SUMPRODUCT(--(MONTH(A1:A100)=MONTH(A1)),--(YEAR(A1:A100)=YEAR(A1))) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs and wildcards to count dates
Il giorno venerd́ 2 ottobre 2015 10:07:23 UTC+2, Claus Busch ha scritto:
Hi, Am Fri, 2 Oct 2015 00:38:42 -0700 (PDT) schrieb I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year. better use SUMPRODUCT: =SUMPRODUCT(--(MONTH(A1:A100)=MONTH(A1)),--(YEAR(A1:A100)=YEAR(A1))) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional I forgot to thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to use wildcards for dates? | Excel Discussion (Misc queries) | |||
COUNTIFS - 2 different scenarios to count | Excel Discussion (Misc queries) | |||
countifs with multiple dates | Excel Worksheet Functions | |||
Countifs -Count no of times products have been sold on particular | Excel Worksheet Functions | |||
countifs Text and Dates | Excel Worksheet Functions |