promotion image of download ymail app

Microsoft Excel Help ?

Attachment image

1 Answer

  • DEBS
    Lv 7
    2 months 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.

    • Commenter avatarLog in to reply to the answers
Still have questions? Get answers by asking now.