Using wildcards in Array formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

hope this is the right XL section for this question. I use the Array formulae
{=SUM((I6:I65536="Strategic*")*(G6:G65536="France"))} where Strategic has
many different narrative types. I have checked the array is syntactically
correct as i entered one of the strategic 'types' into the formulae and it
works ok. Should i be using the * as the wildcard, or another character
please?

Any help appreciated on this as its Friday pm and my brain is effectively
fried for the week.

Thanks
John
 
{=SUM((I6:I65536="Strategic*")*(G6:G65536="France"))}
but you don't need an array formula -- faster is:
=SUMPRODUCT(--(LEFT(I6:I65536,9)="Strategic"),--(G6:G65536="France"))
 
Back
Top