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