Count number of values in a range that exist in a named range in Google Sheets

[MoniqueJC]

I have a list of products, and a daily schedule for several beauticians - I want to count the number of bookings on the schedule (EG. COLUMN C IN PIC A) that contain any value in the 'products' named range (PIC B). I've tried countif(range,named_range) and countifs(range,named_range) but this returns zero

 

[Radoslaw Poprawski]

minisheet please

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[MoniqueJC]

I'm actually working in Google Sheets

 

[Fluff]

In that case you should have asked the question in the General Discussion & Other Applications section of the site & made it clear that you are using Sheets (I have done this for you)

Whilts Excel & Sheets share a lot in common, there are also lots of differences.

 

[MoniqueJC]

In that case you should have asked the question in the General Discussion & Other Applications section of the site & made it clear that you are using Sheets (I have done this for you)

Whilts Excel & Sheets share a lot in common, there are also lots of differences.

thanks so much, but I'm battling to find it - apologies, I'm new to this forum

 

[Fluff]

I have already moved it for you, so there is nothing you need to do.

 

[Fluff]

Not sure if this will work in sheets

=SUM(COUNTIFS(C:C,Products))

It may need to be wrapped in arrayformula