Is there a neater/faster way than having to use worksheet functions and iterating through an array to find values.

my example - I have an array containing the following:
AAAA ZZ 0001
BBBB ZZ 0001
AAAA XX 0001
BBBB ZZ 0001
AAAA XX 0001

I'm aiming to search for 'AAAA' and 'XX' which would return a subtotal of 2.
If this needs more explain - give a shout.
Cheers,
Matt.