I want to say =COUNTIFS($A:$A,OR("OCT","NOV","DEC")) but that doesn't seem to work.
I also have the dates stored here so I could do something like greater than Oct 1 and less than Dec 31, if that helps
I want to say =COUNTIFS($A:$A,OR("OCT","NOV","DEC")) but that doesn't seem to work.
I also have the dates stored here so I could do something like greater than Oct 1 and less than Dec 31, if that helps
One way...
=SUM(COUNTIF($A:$A,{"OCT","NOV","DEC"}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Maybe like this:
=COUNTIFS(A:A,">=01/10/2014",A:A,"<=31/12/2014")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Alternative, assuming a Date value is in A
Use Control + Shift + Enter to enter this Array Formula. I recomend replacing A:A with the actual range to speed up calculations.
=SUM(--(MONTH(A:A)={10,11,12}))
Advise you use something like this instead though, assuming 500 rows of data:
=SUM(--(MONTH(A1:A500)={10,11,12}))
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Thank you Glenn Kennedy, that worked. Any idea why the quotes are necessary? That doesn't make sense to me since the dates are values in my spreadsheet.
Speshul, does using defined ranges like that actually calculate quicker than using an entire column/row??? So many of my spreadsheets take FOREVER to calculate, this could be a lifesaver!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks