Thread: Sumif/Sumproduct over two columns?

Hi,

I am trying to find an amount for certain strains of text over two columns
I have used sumif to the effect of looking in column A for a certain word/phrase "A103" and then when its found using the amount from column C to populate a certain cell.

I am now looking to expand the amount from not just column C but also column D, is this possible and if so what is the code?

example below

=SUMIF(A:A,"A103",C:D)

Thank you in advance

Try:

=SUMIF(A:A,"A103",C:C)+SUMIF(A:A,"A103",D:D)