Trouble creating COUNTIFS
For the life of me I cant get SS to sum certain target values.
For example I have an "Audit Status" column with drop down functions, some of these functions represent being "completed" and I have a sheet that I want to reference these variables as combined.
i.e. Completed, Not Required, QC Complete, and Bypass QC all mean that we have had an auditor onsite, but I cant get them to calculate in another worksheet as a reference calculation.
I tried unsuccessfully to use the "or" function and the "&" but always get 0 as the returned result... Im stumped