View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Edward Wang Edward Wang is offline
external usenet poster
 
Posts: 18
Default Conditional sum in an array

I need to make a flexible sum in an array( not a single column or row). Say:
1. sum range: B2:Z20
2. Criteria1 range: B1:Z1
Criteria 2 range: A2 A20

Any data in the sum range will be summed up if the conditions meet in the
the criteria ranges.