Difference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In terms of funcionality what's the difference between

=SUMPRODUCT((A2:D2)*(A4:D20=1))

and

=SUMPRODUCT(($A$2:$D$2)*($A$4:$D$20=1))

This is with respect to a previous inquiry. They do the
Same thing. What is the significance of $
 
The dollar signs make the reference a FIX reference, if
you drag or fill down the formula the reference will not
change, with out the dollar signs the refences in the
formula will be relative to the cell were the formula is
written. i.e.

If you have =A1 in B1 and you copy an Paste in C1 it will
be =B1.
But if you have =$A$1 It will still be =$A$1 regardless of
were you paste it...

Cheers
Juan
 
THANKS!!
-----Original Message-----

The dollar signs make the reference a FIX reference, if
you drag or fill down the formula the reference will not
change, with out the dollar signs the refences in the
formula will be relative to the cell were the formula is
written. i.e.

If you have =A1 in B1 and you copy an Paste in C1 it will
be =B1.
But if you have =$A$1 It will still be =$A$1 regardless of
were you paste it...

Cheers
Juan



.
Click to expand...
 
Back
Top