Maybe some of the values you want to sum are text?


=SUMIF(Range1,criteria,Range2)

are both ranges of the same size


Regards,

Peo Sjoblom

"puzzledfe" wrote:

I cannot get SUMIF to work on Excel 2002, perhaps I am missing something. I
have a column named PROB, and within this column I have text criteria e.g.
CON or POSS, elsewhere in a different column on the same sheet I have
financial data, that I want to sum according to the criteria. I have tried
SUMIF(PROB,"CON",[sum range], but it does not return the sum I am expecting,
indeed with various experiments I am completely at a loss about what it is
returning except under certain conditions it will return the value in a
single cell OK.