Hi All --
Goofy question. I have an array formula that when I drag and drop copy to more than one cell, when I save Excel crashes. I can do it one cell at a time. Here are the 3 instances:
=SUM(IF($C$60:$C$80=1,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
=SUM(IF($C$60:$C$80=2,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
=SUM(IF($C$60:$C$80=3,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
where h56 is a date. I want to drag the column to copy but crashes when I save. I am using Excel97. (I know I know, dont have a choice though.)
Thanks!!
Goofy question. I have an array formula that when I drag and drop copy to more than one cell, when I save Excel crashes. I can do it one cell at a time. Here are the 3 instances:
=SUM(IF($C$60:$C$80=1,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
=SUM(IF($C$60:$C$80=2,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
=SUM(IF($C$60:$C$80=3,IF($F$60:$F$80<=H$56,$E$60:$E$80,0),0))
where h56 is a date. I want to drag the column to copy but crashes when I save. I am using Excel97. (I know I know, dont have a choice though.)
Thanks!!