Hi,

Try this array formula (Ctrl+shift+Enter)

=sum(if((A2:A20="cond1")*(B1:Z1="cond2"),B2:Z20))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Edward Wang" wrote in message
...
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.