Formula to check 2 columns and give a total



Im looking to create a dashboard that tracks MI tasks, but within 1 sheet it will contain multiple proejcts.

To combat this, i have created a "header" field, this marks the title of each project.

Each project also has a status

Is there a formula i can write that checks if header is ticked, then count status as 1 if "in Progress" and it would check these 2 rows, and calculate a total wherby header is ticked and status is In Progress?


  • KPH
    KPH ✭✭✭✭✭✭

    Do you want to count the number of rows in the sheet that have a check in the Header column and "In Progress" in the Status column?

    If so, the COUNTIFS function will do what you need. This formula will count rows where the value in the column Header is 1 (which is checked if this is a check box) and the value in the column Status is "In Progress".

    =COUNTIFS(Header:Header, 1, Status:Status, "In Progress")

    If this is not what you are trying to do, please share more details.