1. nioc98

    Solved Excel index error?

    Problem: I am using the formula: =INDEX(G3:G12,COUNTA(G3:G12)) to extract the last number in a range of 10 cells G3:G12. Some of the cells are blank. It works until I enter a formula (for example in cell G4: =IF(B4="","",G3) to keep the G3:G15 cells blank if an adjacent cell, say B4, is blank...