AVERAGEIF replacement for office 97

[LORDMARKS]

Hi all

My work is still on office 97 so I am having trouble trimming the fat off some of my workbooks. Is there a simple way to replace the newer AVERAGEIF statement so I can run the same function on 97.

i need the function to look at 1 row and average the values that are below one of 4 headings. So when repeated I will have four total at the end of the row that relate to each heading. This is to allow me to change the headings.

thanks in advance

 

[skywriter]

You can try the formula in D4, it's an array formula so you will have to hit control+shift+enter when you accept the formula. Excel will put the curly brackets at each end of the formula after you do this. You can not type in the curly brackets manually it will not work.

This all assumes array formulas were around in Excel 97 as well as the average and if functions. I didn't even know what functions were when I had Excel 97, I don't even think I used Excel 97 back then, probably just Word.

Good luck, let me know if you need any more help.

Excel Workbook
	C	D	E	F	G	H	I
1	*	*	*	*	*	Jim	8
2	*	*	*	*	*	Frank	22
3	*	Excel 97	Excel 2010	*	*	Joe	24
4	Jim	20.7	20.7	*	*	Bill	36
5	Frank	23.7	23.7	*	*	Ed	12
6	Joe	31.0	31.0	*	*	Jim	9
7	Bill	20.3	20.3	*	*	Frank	44
8	Ed	12.0	12.0	*	*	Joe	55
9	*	*	*	*	*	Bill	24
10	*	*	*	*	*	Ed	15
11	*	*	*	*	*	Jim	45
12	*	*	*	*	*	Frank	5
13	*	*	*	*	*	Joe	14
14	*	*	*	*	*	Bill	1
15	*	*	*	*	*	Ed	9
Sheet1