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