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