Sumif formula and multiplying the sum range

[finance123]

I'm trying to write a sumif formula so that if cell N1 equals 2 then multiply cells A1 and C1 and if cell N2 equals 2 then multiply A2 and C2, then add the two results. Any suggestions?

[tigeravatar]

finance123,

This should work for you:

Please Login or Register  to view this content.

[finance123]

Is there anyway to edit that formula so that it will work for cell N1 through N100?

[tigeravatar]

I didn't do it this way to begin with because with just 2 instances it was shorter and easier to do the formula manually.
Here's the formula to allow for N1:N100

Please Login or Register  to view this content.