Return sum of adjacent matching cells

Originally Posted by thisandthat

=SUMIF(A:A,"A",B:C)

The sum range B:C has to be a single column.

You could do like this...

=SUMIF(A:A,"A",B:B)+SUMIF(A:A,"A",C:C)