Countifs with two contains

Sylvia Kay

Why does my formula show #UNPARSEABLE?

=COUNTIFS({[Name] Initiative - RAID Log Status}, CONTAINS($[Column7]$120, @cell), {[Name] Initiative - RAID Log Action Owner}, CONTAINS(Input@row, @CELL))

$[Column7]$120 includes the word "open"

Input@row contains a name

Reference {[Name] Initiative - RAID Log Status} is a column with a dropdown

Reference {[Name] Initiative - RAID Log Action Owner} is a multiple choice dropdown

I like to count all open items for a particular person by:

1. counting all items that are either "open (active)" or "open (blocked)"
   1. here I use "CONTAIN the word open from the cell $[Column7]$12
2. and that contain the name displayed in "Input@row"

Paul Newcome

Your last CONTAINS function has "@CELL", but it needs to be all lower case "@cell".