Trouble creating COUNTIFS

nbetters65246

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

 

 

Shaine Greenwood

Hi,

COUNTIFS will only count data that meets all criteria. Try adding COUNTIF functions together:

=COUNTIF({cross-sheet reference}, "Completed") + COUNTIF({cross-sheet reference}, "Not Required")

More on COUNTIF can be found in the help center: https://help.smartsheet.com/function/countif

Paul Newcome

It is possible to use the AND and OR functions within a COUNTIF(S) or SUMIF(S). It would simply be the criteria.

 

=COUNTIFS({Range}, OR(@cell = "Completed", @cell = "Not Required", @cell = "QC Complete", @cell = "Bypass QC"))

 

This will count all instances where any of those are true.