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).
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})
-
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).
-
@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.
-
Try
COUNTIF({MSS Sheet - Sales Pipeline Range 2}, Contains([MSS Account Owner]@row,@cell).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!