Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index use with areas
The example in HELP for Index shows the following:
=Sum(Index(A1:C11,0,3,1))... The sum actually adds up both area 1 and 2 and not just column 3, area 1. What is the proper format to add up just column 3, area 1? -- charlie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index use with areas
=sum(C:C)
"charlie" wrote: The example in HELP for Index shows the following: =Sum(Index(A1:C11,0,3,1))... The sum actually adds up both area 1 and 2 and not just column 3, area 1. What is the proper format to add up just column 3, area 1? -- charlie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index use with areas
Surely in your formula you have only one area: A1:C11
For two areas you need something like INDEX((A1:B11, C1:C11),0,3,1))... Your formula correctly summed column C for me best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "charlie" wrote in message ... The example in HELP for Index shows the following: =Sum(Index(A1:C11,0,3,1))... The sum actually adds up both area 1 and 2 and not just column 3, area 1. What is the proper format to add up just column 3, area 1? -- charlie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index use with areas
Works fine for me.
Also could use: =SUM(INDEX(A1:C11,,3)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "charlie" wrote in message ... The example in HELP for Index shows the following: =Sum(Index(A1:C11,0,3,1))... The sum actually adds up both area 1 and 2 and not just column 3, area 1. What is the proper format to add up just column 3, area 1? -- charlie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index use with areas
Thanks, defining both areas works fine... the sample in the help file is not
correct.. -- charlie "Bernard Liengme" wrote: Surely in your formula you have only one area: A1:C11 For two areas you need something like INDEX((A1:B11, C1:C11),0,3,1))... Your formula correctly summed column C for me best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "charlie" wrote in message ... The example in HELP for Index shows the following: =Sum(Index(A1:C11,0,3,1))... The sum actually adds up both area 1 and 2 and not just column 3, area 1. What is the proper format to add up just column 3, area 1? -- charlie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup areas? | Excel Worksheet Functions | |||
Print Areas | Excel Discussion (Misc queries) | |||
Benifit of AREAS | Excel Worksheet Functions | |||
printing from different areas | Excel Worksheet Functions | |||
Export Areas | Excel Discussion (Misc queries) |