Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum if is only calculating one column
I am trying to calculate more data in more than one column with the sumif
function but it only adds up data in the first column. The formula I have is =SUMIF($A$10:$A$12,$A1,B10:D12) For some reason it only adds up data in column b and not columns b to d as expected. Is this unique to Excel 2003 as I believe I used to be able to do this in older versions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Column Not Calculating | Excel Worksheet Functions |