Formula help SUM(IF((...

[HAL]

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),'Export'!
$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

 

[N Harkawat]

Shouldn't it be 'Export'!A9 instead of simply a9

 

[HAL]

No, A9 is a cell containing text on my report page which
is another sheet separte from Export.
I need this piece *('Export'!$E$3:$E$9999=A9) to take the
value typed in A9 and find that in the sheet called Export.
This one baffles me because it works elsewhere!

 

[HAL]

Solved! A9 was deleted and re-entered.

-----Original Message-----
No, A9 is a cell containing text on my report page which
is another sheet separte from Export.
I need this piece *('Export'!$E$3:$E$9999=A9) to take the
value typed in A9 and find that in the sheet called Export.
This one baffles me because it works elsewhere!

.