LinkBack URL
About LinkBacks
I have a simple formula that counts the number of instances of items occurring in a particular month/ Year.
Is there a better way to do this so I can drag this cell and increment the month?
Please Login or Register to view this content.
I have a simple formula that counts the number of instances of items occurring in a particular month/ Year.
Is there a better way to do this so I can drag this cell and increment the month?Please Login or Register to view this content.
Hi,
Enter a valid date in any cell, say A2:
Use this for monthly increment row-wise:
=TEXT(EDATE($A$2,ROW(A1)-1),"mmmm yyyy")
So your formula will looks like:
=COUNTIF(Sheet '1'!X:X,"*"&TEXT(EDATE($A$2,ROW(A1)-1),"mmmm yyyy"))
Blessing
Khalid
If I understand your requirement
in row 2
=COUNTIF(Sheet1!X:X,$D$1+ROWS($1:1))
where D1=29/02/2016
Date for COUNTIF will increment day by 1 when dragged down
Hi John,Originally Posted by ids
I think OP needs "Month (not days) increment" while dragging down.
Your formula is not counting true dates. It's counting TEXT strings that look like dates.
So, incrementing the month name would be more complicated.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks