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.
|