Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
IF or SUMIF help for Overtime Formula | Excel Worksheet Functions |