COUNTIFS + AND / OR

RosieO

I am trying to count specific information in three columns in my sheet:

1. Is active - Yes
2. Multiple 'needs updates' dropdown options
3. 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

parulmishra

Is it the missing "comma" after [Is Active]:[Is Active],"Yes"

parulmishra

Is it the missing "comma" after [Is Active]:[Is Active],"Yes"

RosieO

@parulmishra I think thats worked! Thank you:)