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

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

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

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

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