It's because when you select the entire column it's including the word
Location as part of the calculation. If you do the formula as C1:C34 you'll
get the same result as C:C--both wrong. The sum range should exclude any
cells that aren't going to be used in the calculation.

"abis" wrote:

Hi Pete, Thanks I have tried that - it takes me to row 65536. In cell C1
there is a title row containing the word 'Location'
Thanks
Abi

"Pete_UK" wrote:

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