Difference

[Guest]

In terms of funcionality what's the difference between

=SUMPRODUCT((A22)*(A420=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 $

 

[Juan Sanchez]

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

 

[TN]

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



.