ISTEXT(@cell) when cross referencing a sheet
I am new to cross sheet formula's and a formula that works locally on a sheet, I am trying to cross reference so that the data that I successfully found will be on another sheet. Here is the formula that I used on the local sheet
=COUNTIFS([Rep Completion Confirmation]:[Rep Completion Confirmation], "", VIN:VIN, ISTEXT(@cell))
when cross referencing I am not sure how to add the ISTEXT(@cell) portion.
Any help would be much appreciated!
Help Article Resources
Check out the Formula Handbook template!