cross sheet countif formula
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.