COUNTIFS in Sheet Summary Formula

sharshman

Hello,

I am trying to create a Sheet Summary variable that captures milestones completed last quarter.

I have the following formula in the summary sheet field:

=COUNTIFS(Status:Status, "Complete", Start:Finish, AND(@cell >= IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 4, 1), DATE(YEAR(TODAY()) - 1, MONTH(TODAY()) + 8, 1)), @cell < DATE(YEAR(TODAY()), MONTH(TODAY()), 1)))

But for some reason I keep getting the "incorrect argument set"

The status column is categorical, and Start/Finish are dates. Any help would be greatly appreciated. I hope to then move this output into a dashboard too.

Thank you!

Stephanie

Paul Newcome

The problem is that your first range is a single column and your second range is (at least) two columns wide. You will need to adjust this so that both ranges are the same size and shape.

Paul Newcome

The problem is that your first range is a single column and your second range is (at least) two columns wide. You will need to adjust this so that both ranges are the same size and shape.

sharshman

Thank you!

Paul Newcome

Happy to help. 👍️