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!
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!