Help with COUNTIFS formula with 3 criteria referencing a different sheet

NV Smith

Can some one please help create a formula referencing a sheet named FSER Project Plan that meets the following requirements:

1. The helper column titled Level = 1
2. The column titled CATEGORY = PROJECT PLANNING, and
3. The column titled STATUS = COMPLETE?

Thank you in advance for any help.

prime_nathaniel

@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