The formula is displaying a relative relationship to the column that the
formula is in. For example: If your formula is in column 4 then 2 columns to
the right is column 6. 40 columns to the right is column 44.

Mike F
"jln via OfficeKB.com" <u25956@uwe wrote in message
news:6afea1e594442@uwe...
Nick that what i thought but im not using column 2 im using 6. I have
recorded for about 20 lines all using column 6 and they all say 2. SO how
can
that be the column number?

Nick Hodge wrote:
jln

The [C]2 is R1C1 notation, the C is for 'Column' and the 2 is Column 2 so
B
and as it has no '[R]' refers to the whole column. (Lookup Range)

The 1 is the criteria and the second [C]40 is the range that is summed
Column 40

I trying to fig out what the formula is doing/

[quoted text clipped - 5 lines]
is
the work sheet. What is C? what is 40?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200612/1