I am trying to count specific information in three columns in my sheet:
- Is active - Yes
- Multiple 'needs updates' dropdown options
- Multiple file types
I tried this:
=countifs([Is Active]:[Is active] "Yes",[Asset Status]:[Asset Status], OR(@cell <> "Needs update - new brand", @cell <>"Needs update - legal changes"),[File Type]:[File Type], OR(@cell <>"PPT", @cell <>"docx"))
But am getting #unparseable
Please can someone advise? Thanks in advance
Rosie
