Array Formula: can anyone suggest a better option?

H Guys - Looking for some help with the following formula:

{=sum(if((Asset_Client="ZHK*")*(Asset_Age=A7),1))}

Basically - I'm counting the number of times that both of the above are relavant in a range.

The ZHK* should pick out anything starting with ZHK - but does not seem to work, can anyone suggest a better option?

Cheers, Neil

Hi Neil

Try using sumproduct - look at the link below

http://xldynamic.com/source/xld.SUMPRODUCT.html

Ed

Thanks guys - works fine.

And a very useful link to SUM Product info - thanks.