Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a portion of a spreadsheet with 13 columns and 119 rows of data (from
BE5 to BQ123 - with each row being designated as "HOV Freeway" "Freeway" or "Arterial" in column C). I tried to perform a simple sum on this data IF the row is a "HOV Freeway". So the formula I used was: =(SUMIF(C5:C123,"HOV Freeway",BE5:BQ123))... I didn't get any type of error, excel seemed to accept the formula and gave me a value of 24889.6, but that value is just the Sum of BE5:BE123. When doing a quick check, the real value should be 281261.0... not even close to what excel calculated for me. My question is, why didn't I get an error if it is only going to sum one column, instead of the 13 columns I thought I was asking for in the formula? Is there a way to sum all of those columns and rows, using SUMIF? Does the range you specify for SUMIF correlate to the sum_range (ie, if the 'if' range is only 1 column, the sum_range can only be returned for 1 column)? I really need this to work for 13 columns. Thanks a lot for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif problems | Excel Discussion (Misc queries) | |||
SUMIF problems | Excel Worksheet Functions | |||
sumif problems | Excel Discussion (Misc queries) | |||
Problems with SUMIF() | Excel Worksheet Functions | |||
Sumif Problems | Excel Discussion (Misc queries) |