Hi Kris,

Sorry there is some typos in my request. Corrected in **red**.

Hi there. I have 3 separate columns (Column H, J & **L**) that has the "index and match" formulas going vertically downwards. I've created another Column **M** to sum the row results of Column H, J & **L** respectively. However, since the "index and match" formulas in Column H, J & **L** always return #N/A results it is certain that I'll have the same #N/A for my sum in Column **M**. Even when 1 of the 3 columns has valid data (a figure) the sum in Column **M** will return the same #N/A.

I have searched for a solution and this was the formula that was recommended in another post but it works only for consequetive cells. How do I tweak in order for it to work on interval cells.

=SUM(IF(ISNA(C4:C11),0,C4:C11)) - Needs to be entered with Ctrl + Shift+ Enter

Your immediate assistance is much appreciated. Thanks in advance.