jln

Just spotted I have brackets all over the place, they should be around the
number...sorry

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Nick Hodge" wrote in message
...
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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"jln via OfficeKB.com" <u25956@uwe wrote in message
news:6afe660e3e8b6@uwe...
I trying to fig out what the formula is doing/

FormulaR1C1 = "=SUMIF(TOEPIEXP!C[2],1,TOEPIEXP!C[40])"

TOEPIEXP!C i know that TOEPIEXP is the worksheet what is the C?

[2],1,TOEPIEXP!C[40])" What is the [2] ? The 1 is the criteria. TOEPIEXP
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