Trying to count the value in my multi select column

toni.toni601

Trying to add the unique values in a multi-select form after a criterion is met.

Here's the formula I'm trying to use:

=SUMIFS({Business Area}, [column8]@row, {Imp Group}, Label@row, {Business Resources})

Now, If the business area is the value at the row (Admin), and the imp group, is value at the row (day 0), then add the values in the Business Resources column.

NOTE: I used the CountM formula to get the values in the Business Resources column.

Table looks similar to this:

With the correct automated formula, I'd like to achieve the values in the shaded total columns in screenshot.

Any ideas?

Paul Newcome

It looks like your syntax is a little off. WIth SUMIFS, the range to sum comes first.

=SUMIFS({Business Resources}, {Business Area}, [column8]@row, {Imp Group}, Label@row)