Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 v 2003
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 v 2003
On Wed, 9 Apr 2008 01:53:00 -0700, Leon wrote:
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? They seem very useful. But you could probably get similar results using SUMPRODUCT. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007/2003 | Excel Discussion (Misc queries) | |||
Excel 2003 and 2007 in same PC | Excel Discussion (Misc queries) | |||
Excel 2003-2007 (another one) | Excel Discussion (Misc queries) | |||
Excel 2003 to 2007 | Excel Discussion (Misc queries) | |||
2007 & 2003 Excel | Excel Discussion (Misc queries) |