Excel 2007 v 2003

L

Leon

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. Could I
have used different formulae or are these new formulae as powerful as they
appear?
 
R

Ron Rosenfeld

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. Could I
have used different formulae or are these new formulae as powerful as they
appear?
Click to expand...

They seem very useful. But you could probably get similar results using
SUMPRODUCT.
--ron
 
Top