What does the "I" in the above formula mean and how is it used?
D David Biddulph Mar 24, 2008 #2 The I identifies the column. It is the 9th column from the left. The left hand column is A, the 2nd column is B, and so on. Your formula will give you the total of the numbers in the 47th to 115th rows (inclusive) in the 9th column.
The I identifies the column. It is the 9th column from the left. The left hand column is A, the 2nd column is B, and so on. Your formula will give you the total of the numbers in the 47th to 115th rows (inclusive) in the 9th column.