Often people have array formulas set up in their Excel workbooks but are not sure how they work. (you will usually know an array formula because of the { and } brackets at the ends. Often these array formulas are counting or summing some values based on multiple criteria (city 'ABC" and month "Jan" for instance (note the count array function will use SUM & IF)
How these array formulas work is too complex for this most BUT the good news is that COUNTIFS & SUMIFS in Excel 2007 or excel 2010 functions will usually replace them. Just work out what the criteria is and test
MS Excel 2010 formulas, COUNTIFS & SUMIFS Toronto Excel training
Bert Twomey
MS Office & Excel trainer
Mississauga, Toronto, Ontario
905-271-1119
