Referencing Another Sheet Formula Help!

laura.sandoval

I'm trying to find the right formula for this column to count the number of times the left side shows up in the "Master Site Contact Sheet" but it keeps giving me an error. Can someone please help me with this formula, what am I doing wrong?

Paul Newcome

Try an @cell reference in the HAS function.

HAS(@cell, [Primary Column]@row)

laura.sandoval

Thanks going to try that now! I was hoping you could help me with another formula? I added a column in a sheet that is sourced from another sheet...it's for text not numbers. Which formula would I use for this one?

Paul Newcome

I'm not sure I follow...

laura.sandoval

Hmm I think I may have explained it weird, excuse the confusion. I have a column from another sheet that I want to add to this sheet...is that something I can do?

Paul Newcome

If you have a unique identifier that you can match on, you can use an INDEX/MATCH.

=INDEX({Column To Pull From}, MATCH([Unique ID]@row, {Unique ID Column}, 0))

laura.sandoval

Thank you that was helpful! Going back to the first one...it worked! I did have an additional question though.

This is the formula I used: =COUNTIF({All Site Contact Sources}, HAS(@cell, [Primary Column]@row))

If I had a critera that it needed to have for it to be counted, how can I do that in the formula? For this instance, the number will be counted if it's in the "All Site Contact Sources" but I would like it to be counted only if it has a dropdown item from a column in that sheet. I'm trying to count only the "active sites" and I want that to be a criteria. Hope that makes sense and thank you Paul!!

Paul Newcome

You would use a COUNTIFS (with the "S" on the end) and then include the additional range/criteria set following the same syntax of "range, criteria, range, criteria".