Array / fill down question

[Ann Scharpf]

With guidance from previous posts, I did my first
SUMPRODUCT() array formulas today. When I create the
original formulae and CTRL-SHIFT-ENTER, I get the {}
braces around the entire formula.

However, when I fill down, the outside {} braces are not
copied with the formulae. I still seem to be getting
proper results but I know that you get messed up if you
forget the CTRL-SHIFT-ENTER when you create the formula
and I'm concerned that down the road, something goofy may
happen to my worksheet since the {}s are missing.

I've looked through the archives and don't see any info
about this question. Do I need to be concerned or is the
sheet ok as is?

Thanks for your help.

Ann Scharpf

 

[Aladin Akyurek]

SumProduct formula, all things being equal, do not confirming with
CTRL-SHIFT-ENTER. Just enter suffices.

 

[Aladin Akyurek]

Meant to write:

SumProduct formulas, all things being equal, do not need confirming with
CTRL-SHIFT-ENTER. Just enter suffices.

 

[Dave R.]

Still there's a mystery of why the {} are stripped off as a result of
"filling".

 

[Ann Scharpf]

-----Original Message-----
Aladin Akyurek wrote:

SumProduct formulas, all things being equal, do not need

confirming with CTRL-SHIFT-ENTER. Just enter suffices.

_________________________________________

Here is my formula. I'm getting confused. Do I need the
CTRL-SHIFT-ENTER or no?

=SUMPRODUCT(--(System="DIFMS-C"),--
(LaborType="MAINTENANCE"),--(UserID=$A4),Reg)

System, LaborType and Reg are all named ranges.

Thanks for your help.

Ann

 

[Dave R.]

No.

confirming with CTRL-SHIFT-ENTER. Just enter suffices.

_________________________________________

Here is my formula. I'm getting confused. Do I need the
CTRL-SHIFT-ENTER or no?

=SUMPRODUCT(--(System="DIFMS-C"),--
(LaborType="MAINTENANCE"),--(UserID=$A4),Reg)

System, LaborType and Reg are all named ranges.

Thanks for your help.

Ann