Thread: Index, Match, Sum ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default Index, Match, Sum ??
Hi,

Try something like this in Cell T49

=SUMPRODUCT((A2:A32=1)*(AT2:CAT32))

Regards,
Bondi

Reply With QuoteReply With Quote