My array formula as follows returns a 0 but should not.
=SUM(IF(('Export'!$G$3:$G$9999=1)*('Export'!
$B$3:$B$9999=32)*('Export'!$E$3:$E$9999=A9),'Expor t'!
$J$3:$J$9999))

The A9 on the sheet with the formula is my problem...Can
someone please tell me why it can't find that on the sheet
called Export?

If I change A9 to the actual "text" I'm looking for it
works. Both A9 and the range on the Export sheet are
formatted as General. (="A9" does not work either.

TIA