| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUM(I47:I115) What does the "I" mean and how is it used?
What does the "I" in the above formula mean and how is it used?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUM(I47:I115) What does the "I" mean and how is it used?
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. -- David Biddulph "Julie Ibarra" <Julie wrote in message ... What does the "I" in the above formula mean and how is it used? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUM(I47:I115) What does the "I" mean and how is it used?
And SUM(A1:H1) will sum the first eight cells on the top row
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Julie Ibarra" <Julie wrote in message ... What does the "I" in the above formula mean and how is it used? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
