Excel 2007 Functions
One of the great aspects of the Excel 2007 is the new
functions. I have used COUNTIF and SUMIF numerous times and often found I wanted
to do multiple criteria, i.e. sum if revenue is for this month and for this
store. To achieve this before 2007 you had to jump throuhg numerous hoops and it
all became very complex.
The great news is that SUMIF and COUNTIF functions have been extended to take
more than one criteria. These are implemented using SUMIFS and COUNTIFS. These
both can take up to 256 criteria (more than I can imagine anyone ever
needing).
You can now produce very complex summary sheets very
easily.
-