Check that

1) your PROB column "CON" entries don't have extraneous spaces, and

2) that your [sum range] is actually numbers rather than text (a common
problem when pasting in from a web browser). To coerce text numbers to
real numbers, copy an empty cell, select your [sum range] and choose
Edit/Paste Special, selecting the Values and Add radio buttons.


In article ,
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.