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!😀

Will

Find more posts tagged with

Accepted answers

Mark Cronk

Hi,

Try:

=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.

Work?

Mark

All comments

Mark Cronk

Hi,

Try:

=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.

Work?

Mark

Will Hughes

Good morning Mark,

That works, thank you so much! You've just saved me a lot of time!!

Best wishes

Will

Will Hughes

I'm also trying to do the same formula with the criteria that the 'attended' field equals 'Yes'

I've tried: =COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [Primary Column]@row {April/May 2021 Boot Raw Data Range 2}, "Yes")

But get #UNPARSEABLE. Could you recommend the correct way?

Many thanks,

Will

Will Hughes

Never mind - I figured it out! :)

Mark Cronk

Perfect.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.