Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to use wildcards for dates? MildJoe Excel Discussion (Misc queries) 3 April 7th 23 12:17 PM
COUNTIFS - 2 different scenarios to count Roady Excel Discussion (Misc queries) 2 February 9th 10 11:06 PM
countifs with multiple dates majestyk Excel Worksheet Functions 2 February 10th 09 08:31 PM
Countifs -Count no of times products have been sold on particular kje.1953 Excel Worksheet Functions 4 November 20th 08 09:39 AM
countifs Text and Dates mokihi Excel Worksheet Functions 7 September 4th 08 05:30 AM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"