Thread: Index use with areas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie Charlie is offline
external usenet poster
  
Posts: 703
Default 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
Reply With QuoteReply With Quote