Getting countif to work between sheets

Krystal Vaughn

I can not get the countif function to work between 2 separate sheets. One of the sheets is my metrics for the pipeline. I want to get a count of how many times a name(account holder) is used on the pipeline and I keep getting the error unparseable or incorrect argument. I try linking the sheets and get the same errors. I am pretty new to smartsheets so any help would be greatly appreciated. Is there a general formula to use, as the ones I have found are not working.

RossL

@Krystal Vaughn

Try

COUNTIF({MSS Sheet - Sales Pipeline Range 2}, Contains([MSS Account Owner]@row,@cell).

Krystal Vaughn

I have this formula but it is not counting the ones where theres 2 names in one cell from a drop down list

=COUNTIF({MSS Sheet - Sales Pipeline Range 2}, {MSS Account Owner})

RossL

@Krystal Vaughn

is the MSS Account Owner column on the metrics sheet that you want the count to show up on?

if it is your formula should be

COUNTIF({MSS Sheet - Sales Pipeline Range 2}, [MSS Account Owner]@row).

Krystal Vaughn

@RossL Thank you so much! That worked! where do I put CONTAINS at, as I have a drop down list and some cells with more that one person and I want to make sure they are all counted.

RossL

@Krystal Vaughn

Try

COUNTIF({MSS Sheet - Sales Pipeline Range 2}, Contains([MSS Account Owner]@row,@cell).