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. |
#2
|
|||
|
|||
Sum if is only calculating one column
Not unique to 2003, all versions of sumif has this, one possible way
=SUMPRODUCT((A10:A12=A1)*(B10:D12)) -- Regards, Peo Sjoblom "KoriBustard" wrote in message ... 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. |
#3
|
|||
|
|||
Sum if is only calculating one column
On Mon, 24 Oct 2005 09:36:16 -0700, "KoriBustard"
wrote: 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. {=SUM(($A$10:$A$12=A1)*(B10:D12))} Array formula entered with CTRL SHIFT & Enter will achieve what you want. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
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 |