Clay Icon
Join the Community
02 Support

Using COUNTIF Across Tables in Excel: A Quick Guide

Avatar of Jason Z.Jason Z.
·
·

Hey clay, is it possible to run a countif function in one table, looking up data in another table

2 comments

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Jason, thanks for reaching out. Using the lookup multiple rows integration will be the best bet to count the instances of a specific identifier in a separate table. Here's how if would work: https://www.loom.com/share/e00f796e8a6d4ebaa3feace9f45b7593?sid=e542e8f0-1317-4f83-b275-493f016e3de4 I hope this was helpful. If there's anything else I can assist you with, please let me know!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.