Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |