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

Find more posts tagged with

Sheets

Cell linking

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…