Counting multiple cell options in one formula

Ed Gadd

Hoping someone can help with this?

I have a drop down column with multiple options. Of these options more then one can be selected for each cell.

Of these multiple options I'd like to count if one of eight values appears once in each cell and in which month / year the project function completed the task.

This formular work for an individual function, I know the HAS formula might work better.

=COUNTIFS({FUNCTION}, CONTAINS($[Column4]$1287, @cell ), {Expected}, IFERROR(MONTH(@cell ), 0) = $[Column4]@row, {Expected}, IFERROR(YEAR(@cell ), 0) = [Column5]$157)

Expanding this formula to this to count the multiple options, but invalid data type is returned? I was hoping to expand the HAS(@cell,) to the eight items.

=COUNTIFS({FUNCTION}, OR(HAS(@cell, [Column15]1318), HAS(@cell, [Column15]1319), {Expected}, IFERROR(MONTH(@cell ), 0) = $[Column4]@row, {Expected}, IFERROR(YEAR(@cell ), 0) = [Column5]$157))

Is this a simple mistake or the wrong formula? Any help very much appreciated.

Paul Newcome

You just forgot to close out your OR function.

=COUNTIFS({FUNCTION}, OR(HAS(@cell, [Column15]1318), HAS(@cell, [Column15]1319)), {Expected}, AND(IFERROR(MONTH(@cell), 0) = $[Column4]@row, IFERROR(YEAR(@cell), 0) = [Column5]$157))