Excel formula help

[gwhiz921]

Hi, I am having a hard time for the below formulas for my sheet.

1. I need a formula that shows OPEN tasks for the current month and Closed tasks for the current month. This formula will be displayed on the first sheet but pulled from the data pull sheet as shown in picture.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=FILTER(Table1,(TEXT(Table1[Created],"mmmyy")=TEXT(TODAY(),"mmmyy"))*((Table1[Progress]="Open")+(Table1[Progress]="Closed")))

Change table name to suit

 

[gwhiz921]

Hi & welcome to MrExcel.
How about

=FILTER(Table1,(TEXT(Table1[Created],"mmmyy")=TEXT(TODAY(),"mmmyy"))*((Table1[Progress]="Open")+(Table1[Progress]="Closed")))

Change table name to suit

Could I use an if function instead?

 

[Fluff]

Not really, does the formula I suggested not work?

 

[gwhiz921]

I'm not sure what i need to change to get your formula to work.

I was able to use the formula below to count the occurences in a specific month:

=SUM(IF(MONTH('Data Pull'!B2:B500)=8,))

But i would like to count the occurrences in current month that shows status as open.

the open column is column D on the DataPULL sheet.

 

[Fluff]

Did the formula I suggested work?

 

[gwhiz921]

Did the formula I suggested work?

I'm not sure what I need to edit to get it to work. When i entered it as is, it duplicated the entire table

 

[Fluff]

Will you only have dates from one year?

 

[gwhiz921]

Will you only have dates from one year?

No. I would like for it to show the current month of current year.

 

[Fluff]

In that case how about

=FILTER(Table1,(MONTH(Table1[Created])=MONTH(TODAY()))*((Table1[Progress]="Open")+(Table1[Progress]="Closed")))