{=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"))


"John" wrote in message
...
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