Excel SUM IF Array Formula Tutorial - Free Microsoft Excel Spreadsheet Tips and Tutorials

One way to count the number of cells containing data that meets one or more set conditions in Excel is to use a combination of the SUM and IF functions in an array formula. In this tutorial example each row in the image above contains the wind speed and r

spreadsheets.about.com