Question

Hello,

I have a master data sheet with all my information and another sheet where I have my KPIs/metrics & formulas. I am currently using a COUNTIF formula

=COUNTIF({Project List Range 1}, Labels@row)

this is counting how many projects I have in each status (new, in process, pending, etc.) I would like to add another criteria to this to only count the line if the 'Project Type' column says external. Am i able to do so and how would I add to my existing formula?

thanks!

Nic Larsen · Accepted Answer

You just need to change the COUNTIF to COUNTIFS and add your 2nd range and 2nd criteria =COUNTIFS({Project List Range 1}, Labels@row, Range2, Criteria2

Almonto1 · Accepted Answer

I recommend using the COUNTIFS formula for multiple criteria. Example below!

=COUNTIFS({Project List Range 2}, "External", {Project List Range 1}, Labels@row)

Project list range 2: the project type

Project list range 1: the project status