Sumif on Non-Continuous Range

[acool]

Hi Everyone,

I am currently trying to create a sumif formula that sums the the first twelve months where the value is NOT equal to 0 in the non-continuous range of A2:M2-O2:Z2. I have provided an example of what the outputs should look like in column AB. As mentioned the Range is non-continuous and I would like to sum the first 12 Non Zero Values in the range above.

Thank You!

 

[Fluff]

It's possible if some of the cells are not exactly zero.