Using Countifs to count another sheet using terms from current sheet

Will Hughes

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

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

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.