Using COUNTIF Across Tables in Excel: A Quick Guide

·

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

· Sorted by Oldest

Bruno (Clay)
·
·
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!
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.

Bruno (Clay)
·
·
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!
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.