View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike The Newb Mike The Newb is offline
external usenet poster
 
Posts: 22
Default Sum within an Index Match Statement

I am using an Index Match within a file that could have multiple row (but not
column) based matches. How can I adjust the formula to Sum all the results
instead of just showing the first one?

Formula currently:

=IF(ISERROR(INDEX('2007 PLAN'!$A$1:$DY$10000,MATCH('Month
Template'!$A23,'2007 PLAN'!$B:$B,0),MATCH('Month Template'!$G$1,'2007
PLAN'!$1:$1,0))),0,INDEX('2007 PLAN'!$A$1:$DY$10000,MATCH('Month
Template'!$A23,'2007 PLAN'!$B:$B,0),MATCH('Month Template'!$G$1,'2007
PLAN'!$1:$1,0))).

Month Template A16 is a category of product that could actually be listed
more then once within Column B of the 2007 Plan tab. G1 in the Month Template
is an actual month (i.e. Jan 2007) but it will never appear more then once in
Row 1 of the 2007 Plan tab. I want to sum all the category matches within the
2007 Plan tab after the Index Match does its part.

Thank you in advance.

Regards,

Mike