How do I Sumif from another column?
How do I Sumif from another column? Select a blank cell besides the pasted column, type the formula =SUMIF($A$2:$A$24, D2, $B$2:$B$24) into it, and then drag its AutoFill Handle down the range as you need. Does Sumif only work vertically? The SUMIFS formula works also horizontally. Instead of columns, you can define lookup rows and […]