|
|
|
Special Excel Functions 2003
Special Excel Functions 2007
|
Before you start looking for a solution using macros (VBA) Discover the almighty SUMPRODUCT Function in Excel If you already use SUMPRODUCT in most of your workbooks |
|
|
|
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ COUNTIF ¦ SUMIF ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIFS ¦ SUMIFS ¦ IFERROR