It's not bringing the value for the same date. It's using the value for the
same row. If you were to switch 2 of the dates, the formulas would still
calculate the same as they are now. If you want to ensure they calculate for
the correct date, then your formula in C2 should be something like:
=SUMIF(Sheet1!$B$2:$B$27,B2,range1)*0.01

--
** John C **


"Mike S" wrote:

I was reviewing a formula developed by a fellow employee and cannot figure
out WHY it works.

=(range1)*0.1

facts:
range1 refers to sheet1!$g$2:$g$27
dates in sheet1!b2:b27 are the same as sheet2!b2:b27
formula above is in sheet2 cells c2 to c27

Why does the formula know to bring the value in range1 for the same date? I
have rechecked and 1) the name range1 refers to a single column array of
values and does not include the date and 2) the formual is not entered as an
array formula.

Thanks.

Mike