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.

 

[gwhiz921]

it's still duplicating the table (without the formatting)

 

[gwhiz921]

it's still duplicating the table (without the formatting)

is there something i should be editing within the formula? Could i use countif? or sumif?

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

the formula above shows all entries for august, but can I show entries for current month that shows status as open?

 

[Fluff]

You originally asked for both Open & Closed tasks for the current month, which is exactly what the formula is doing.
Are you now saying you want something different?

 

[gwhiz921]

Sorry for confusion, one formula for open tasks and one formula for closed tasks. I apologize!

 

[gwhiz921]

Sorry for confusion, one formula for open tasks and one formula for closed tasks. I apologize!

i would like it to count how many open tasks are in current month
how many closed tasks are in current month.

 

[Fluff]

In that case try

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

 

[gwhiz921]

In that case try

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

can it give me a numeric value? a count of how many. not the rows.

 

[Fluff]

Why didn't you ask for that to begin with?

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

 

[gwhiz921]

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

this works fine for open.

I plugged in replaced open with closed and the number returned 22. Correct number is 12. Any reason why this might have happened?

 

[Fluff]

Yup that's my mistake, it should be

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

otherwise it's counting all numerical cells in the table