Hi all!
I am currently working on a document where I would like to sum the monthly Google searches for certain group of words. For example, for a particular topic like brands, I have a long list of different brands and would like to add the volume searches of all of them.
I am currently using the following formula:
=SUM(SUMIF(A3:A1510,{"*best*","*reviews*","*top*","*good*","*recommended*","*effective*"},B3:B1510))
As some of my lists are very long, I would like to avoid having to type each keywords.
Also, these are not exact match but I am looking for all cells containing those words or expressions.
Attached, you will find my file in case I did not explain it clearly enough!
As I did not find the answer to my question while doing research online, I was hoping maybe you could help?
Many thanks in advance!
Bookmarks