Counting Number of Requests completed Last Week by Type

Fboivin

I have a metric sheet that I am using to generate a dashboard.

One of the metrics I'm trying to get is the number of Requests completed last week based on the Type of Request A B C.

I have a column for Date completed and a column for Type.

This formula works to get provide the count of all Requests closed last week.

=COUNTIFS({Closed Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Closed Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

I am struggling to figure out how to add in the criteria for the Type. I've tried many many differnet iterations and can't seem to quite crack it.

This is the latest that I tried that does not work

=COUNTIFS({Closed Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Closed Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), AND({Closed by Type}@cell = "B"))

Nic Larsen

If everything else works, then I think you only need to adjust the end slightly.

=COUNTIFS({Closed Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Closed Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Closed by Type}, "B"

Nic Larsen

If everything else works, then I think you only need to adjust the end slightly.

=COUNTIFS({Closed Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Closed Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Closed by Type}, "B"