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
|