Getting countif to work between sheets
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.
Best Answer
-
Try
COUNTIF({MSS Sheet - Sales Pipeline Range 2}, Contains([MSS Account Owner]@row,@cell).
5
Answers
-
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})
0 -
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).
0 -
@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.
0 -
Try
COUNTIF({MSS Sheet - Sales Pipeline Range 2}, Contains([MSS Account Owner]@row,@cell).
5
