Formula to calculate number of tasks marked as "Complete" in Sheet Summary

Sabdelkadir

Hello- I was hoping to get some help with a function I can put in my sheet summary that will populate the number of tasks marked as "Complete" within a given section.

Genevieve P.

Hi @Sabdelkadir

Try using a COUNTIF Function... for example:

=COUNTIF(Status:Status, "Complete")

If your Status column has a name that has spaces or numbers in it, you'll need to wrap that in square brackets:

=COUNTIF([Status Column]:[Status Column], "Complete")

If you only want to look at a specific number of rows, you can add row numbers after the column name. Here's what it would look like for rows 1 - 15:

=COUNTIF(Status1:Status15, "Complete")

See: Create a cell or column reference in a formula

Cheers,

Genevieve

Genevieve P.

Hi @Sabdelkadir

Try using a COUNTIF Function... for example:

=COUNTIF(Status:Status, "Complete")

If your Status column has a name that has spaces or numbers in it, you'll need to wrap that in square brackets:

=COUNTIF([Status Column]:[Status Column], "Complete")

If you only want to look at a specific number of rows, you can add row numbers after the column name. Here's what it would look like for rows 1 - 15:

=COUNTIF(Status1:Status15, "Complete")

See: Create a cell or column reference in a formula

Cheers,

Genevieve

Sabdelkadir

Thank you @Genevieve P. !