Formula help SUM(IF((...
 

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

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

"HAL" wrote in message
...
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

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!

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

"HAL" wrote in
message
...
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



.

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!

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

"HAL" wrote in
message
...
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



.

.