Click in C35, press <End once followed by <down-arrow - does this
take you to the bottom row (65536), or to some other cell which might
be adding to your SUMIF value?

Also, what do you have in C1?

Pete

On Jun 26, 4:50*pm, abis wrote:
Can anyone tell me why when specifying the range in a SUMIF function it
returns different figures if using a column reference (e.g. C:C) and a data
reference (e.g. C2:C34) if C34 is the last cell in the column to contain any
data?

Thanks