Google spreadsheet array formula

[Silha]

Hello all,

This is technically not an Excel question but about Google spreadsheets because I know how to do this on Excel but it won't work on Google spreadsheets.

I need to count all total instances of the word "Freelance" in a column A with a corresponding value of "London" in a column B. All cells in column A containing the word "Freelance" begin with this word, if that helps.

I can count all instances of "Freelance" using the below formula...

=Arrayformula(SUM(ISNUMBER(SEARCH("Freelance",ACTIVE!C:C))+0))

...but I can't seem to work out how to add a second criteria to only count instances of "freelance" in a particular city. Any help on how to do this would be really appreciated.

THANK YOU!!!

 

[J.Ty.]

Hi,

Use the following (adjusted to the location of your data):

=Arrayformula(SUM(ISNUMBER(SEARCH("Freelance",A:A))*(B:B="London")))

J.Ty.

 

[Silha]

It worked a charm, thank you!!!

 

[J.Ty.]

Thanks for the feedback and good luck!

J.Ty.