Array / fill down question

  • Thread starter Thread starter Ann Scharpf
  • Start date Start date
A

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
 
SumProduct formula, all things being equal, do not confirming with
CTRL-SHIFT-ENTER. Just enter suffices.
 
Meant to write:

SumProduct formulas, all things being equal, do not need confirming with
CTRL-SHIFT-ENTER. Just enter suffices.
 
-----Original Message-----
Aladin Akyurek wrote:

SumProduct formulas, all things being equal, do not need
Click to expand...
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
 
No.


Ann Scharpf said:
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
Click to expand...
 
Back
Top