Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting months in a filtered list
I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to do. =MONTH(SUBTOTAL(3,AL12:AL10000)=5) Please help! A1 1 5/1/2017 2 8/15/2017 3 6/15/2017 4 6/15/2017 5 8/15/2017 6 6/15/2017 7 7/30/2017 8 8/15/2017 9 6/15/2017 10 5/2/2017 11 7/30/2017 12 6/15/2017 13 6/15/2017 14 6/15/2017 15 6/15/2017 Desired Output: After Filter Applied Jan 12 Feb 22 Mar 33 Apr 45 May 20 Jun 30 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting months in a filtered list
Sorry Desired Filtered
Output: May 2 Jun 8 Jul 2 Aug 3 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting months in a filtered list
Hi Derek,
Am Wed, 17 May 2017 12:47:41 -0700 (PDT) schrieb DerekE: I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to do. =MONTH(SUBTOTAL(3,AL12:AL10000)=5) Please help! A1 1 5/1/2017 2 8/15/2017 3 6/15/2017 4 6/15/2017 5 8/15/2017 6 6/15/2017 7 7/30/2017 8 8/15/2017 9 6/15/2017 10 5/2/2017 11 7/30/2017 12 6/15/2017 13 6/15/2017 14 6/15/2017 15 6/15/2017 Desired Output: After Filter Applied Jan 12 Feb 22 Mar 33 Apr 45 May 20 Jun 30 try: =SUMPRODUCT(SUBTOTAL(3,INDIRECT("AL"&ROW(12:10000) ))*(MONTH(AL12:AL10000)=5)) Regards Claus B. -- Windows10 Office 2016 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting months in a filtered list
On Wednesday, May 17, 2017 at 4:27:44 PM UTC-4, Claus Busch wrote:
Hi Derek, Am Wed, 17 May 2017 12:47:41 -0700 (PDT) schrieb DerekE: I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to do. =MONTH(SUBTOTAL(3,AL12:AL10000)=5) Please help! A1 1 5/1/2017 2 8/15/2017 3 6/15/2017 4 6/15/2017 5 8/15/2017 6 6/15/2017 7 7/30/2017 8 8/15/2017 9 6/15/2017 10 5/2/2017 11 7/30/2017 12 6/15/2017 13 6/15/2017 14 6/15/2017 15 6/15/2017 Desired Output: After Filter Applied Jan 12 Feb 22 Mar 33 Apr 45 May 20 Jun 30 try: =SUMPRODUCT(SUBTOTAL(3,INDIRECT("AL"&ROW(12:10000) ))*(MONTH(AL12:AL10000)=5)) Regards Claus B. -- Windows10 Office 2016 I get #VALUE as a result |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting months in a filtered list
On Wednesday, May 17, 2017 at 4:27:44 PM UTC-4, Claus Busch wrote:
Hi Derek, Am Wed, 17 May 2017 12:47:41 -0700 (PDT) schrieb DerekE: I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to do. =MONTH(SUBTOTAL(3,AL12:AL10000)=5) Please help! A1 1 5/1/2017 2 8/15/2017 3 6/15/2017 4 6/15/2017 5 8/15/2017 6 6/15/2017 7 7/30/2017 8 8/15/2017 9 6/15/2017 10 5/2/2017 11 7/30/2017 12 6/15/2017 13 6/15/2017 14 6/15/2017 15 6/15/2017 Desired Output: After Filter Applied Jan 12 Feb 22 Mar 33 Apr 45 May 20 Jun 30 try: =SUMPRODUCT(SUBTOTAL(3,INDIRECT("AL"&ROW(12:10000) ))*(MONTH(AL12:AL10000)=5)) Regards Claus B. -- Windows10 Office 2016 That did it Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of unique values in a filtered list | Excel Discussion (Misc queries) | |||
Counting Months | Excel Worksheet Functions | |||
Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
Counting a Filtered List | Excel Discussion (Misc queries) | |||
Counting records in a filtered list | Excel Programming |