@NV Smith you need to create cross sheet references in order to do this, right click on any cell in your target sheet (the one you want data to show up).

Go to manage references.
Create reference, pick the sheet of your soruce data (where you are getting data from).
Pick the column you are getting data from.
Name reference

the format for cross sheet referecnes is {name} and in your case should represent one column of data in your source

assuming

1. The helper column titled Level = 1 is named level
2. The column titled CATEGORY = PROJECT PLANNING is named category
3. The column titled STATUS = COMPLETE? is named status
   

Your formula would be

=countifs({level},1,{category},"PROJECT PLANNING", {status}, "COMPLETE")

Count ifs works in pairs of thing to check, thing to check against.

So {level} is being checked that it equals 1, etc, etc