SUMIF PROBLEM
 

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.

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.

Check to see if the size(# of rows) of both the columns (col PROB and
sumrange) are same.
if PROB is from A1:A110 = 110 rows so is the sumrange 110 rows


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

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.