- DEBSLv 71 month ago
countifs is range, criteria, range2, criteria2, .....
Each range/criteria is an AND with the other range/criteria.
So in your example, you are saying count how many times the Last Name = Reynolds AND the Zip Code = 19104. Visually tallying that, it looks like that only comes up once.