My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Excel 2007 Functions
The new RSS feed is here
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.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Excel 2007 Functions