cross sheet countif formula

tcanelli41471

Trying to find the right formula to count a name column in one sheet based on a specific location in another column.  I've done this successfully with numbers using sumif, but the count isn't working.  Is it not possible?  i tried countif and countifs....keep getting errors.

Robert S.

Hello,

 

I replied to your other post on a similar topic (https://community.smartsheet.com/discussion/cross-sheet-formula-help). The information I gave there is the same as what can be done for this. Please take a look at my response there as well as the article I've linked, and if you have any further questions on this I'll be happy to help.

Brad Jones

How about including the link to the post?? 

That way others who find this post are helped out more.

Robert S.

Good catch! I had every intention of adding the link originally and then completely forgot to. Thanks for pointing this out Brad.