Question on Array Formula

  • Thread starter Thread starter John
  • Start date Start date
J

John

I posted this question earlier, but don't seem to be able
to see the reply. Could you please e-mail me the reply to
the question below to: (e-mail address removed)

I have an array formula in a cell which pulls data from
another sheet like this: {SUM(IF($B$4='Forecast Input'!
$A$2:$A$136,IF($A15='Forecast Input'!$B$2:$B$136,'Forecast
Input'!J$2:j$136)))}. This array formula works fine.
In this same cell, I also want to add the following
formula: W14+(v27/36). But when I add this to the end of
the array formula, the {} around the array formula
disappears and it is no longer an array formula.
Question: how can I add W14+(v27/36) to the end of the
above array (in the same cell as the array formula)and
make it work?
John
 
Not tested with your formula but,
Array formulas, during creation and editing, must be entered with:
C,S,E
Which means, hold down
<Ctrl> + <Shift> when you hit <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I posted this question earlier, but don't seem to be able
to see the reply. Could you please e-mail me the reply to
the question below to: (e-mail address removed)

I have an array formula in a cell which pulls data from
another sheet like this: {SUM(IF($B$4='Forecast Input'!
$A$2:$A$136,IF($A15='Forecast Input'!$B$2:$B$136,'Forecast
Input'!J$2:j$136)))}. This array formula works fine.
In this same cell, I also want to add the following
formula: W14+(v27/36). But when I add this to the end of
the array formula, the {} around the array formula
disappears and it is no longer an array formula.
Question: how can I add W14+(v27/36) to the end of the
above array (in the same cell as the array formula)and
make it work?
John
 
Back
Top