Lindsay

Try this

=SUMPRODUCT(--('rac current line items'!$E$2:$E$65536 = "B/M"),--(YEAR('rac current line items'!$K$2:$K65536)=2008),--(MONTH('rac current line items'!$K$2:$K65536)=6),--('rac current line items'!$F$2:$F65536<>"A-A"))

It doesn't have to be array entered.

rylo