I work in v2007 which has a number of new formulae including COUNTIFS and
AVERAGEIFS. I helped a student with some analytical data using these formulae
but she uses v2003 and the results were lost due to incompatability. I redid
the worksheet using relevant formulae which resulted in an enormous amount of
additional extraction required in order to get to the same answers. Are these
new formulae as powerful as they appear?

The new functions are nice additions since they handle multiple criteria
without resorting to array formulas, which are not intuitive for new users.

--
Jim
"Leon" wrote in message
...
|I work in v2007 which has a number of new formulae including COUNTIFS and
| AVERAGEIFS. I helped a student with some analytical data using these
formulae
| but she uses v2003 and the results were lost due to incompatability. I
redid
| the worksheet using relevant formulae which resulted in an enormous amount
of
| additional extraction required in order to get to the same answers. Are
these
| new formulae as powerful as they appear?