Using Countifs to count another sheet using terms from current sheet

Hi everyone,

I'm working with two sheets - raw data of events bookings and the reporting sheet.

In the reporting sheet ('Data Set') in the 'singed up' column, I've set up a working formula to count the number of times the event name appears in the raw data:

=COUNTIFS({April/May 2021 Boot Raw Data Range 1}, "BLOGGING")

Since the event name is the same as in the primary column of the Reporting Sheet / 'Data Set', is there a formula that would allow me to not include the event name in the formula, but instead, take the name from the 'Event Name' column?

Something like

=COUNTIFS({April/May 2021 Boot Raw Data Range 1}, "Name in Primary Column @Row of April/May 2021 Data Set"),

It's so I can drag the formula down my sheet without having to paste in a new count term each time.

I hope this makes sense! Thanks for your time!😀


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓



    =COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [primary column]@row)

    You can can us this as a column formula or copy and paste it down the column.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!