Are sumifs relevant to what I want to do?

[mikeolson]

I have two columns with no data, but when there is data (a job number) in any cell in these two columns that is a duplicate, I want the quantity (cell in this row) to multiply by the price (another cell in the same row), and return to me the total, and the job number at the end of the row. I know that this is probably really simple, but I'm not having any luck with this. The same job number could be entered into any of the first two columns, so I want a total for each jobs costs.

 

[mrshl9898]

sumifs could be, but i'd go with countifs. count the occurances of the job number in both columns then do your calculation.

something like =IF(COUNTIF(A:A,B2)+COUNTIF(B:B,B2)>1,yourcalculation,"")