Averageif

[RLJ]

I need to have the AverageIF Function work in Excell 97-03. Can I add it into the workbook as a Function in VBA and have it work in both 97-03 and 2010?

If so, what would the function text be that I entered into the VBA Editor?

 

[Scott Huish]

Why not just use a formula that's compatible with both?

 

[RLJ]

=AVERAGEIF('User Template'!$L$5:$L$28,B3,'User Template'!I5:I28)

How can I take this formula to make it work.

 

[Scott Huish]

=AVERAGE(IF('User Template'!$L$5:$L$28=B3,'User Template'!I5:I28))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[RLJ]

I'm perplexed... When I copy this formula down three rows I get a (0.00) value???

=AVERAGE(IF('Joel McRae'!$L$5:$L$2000=$B$3,'Joel McRae'!$I$5:$I$2000))

It should give me the exact same results.

 

[Scott Huish]

It doesn't for me. Did you confirm with CTRL-SHIFT-ENTER?

Excel Workbook
	B	C	D
1			22.5
2			22.5
3	12		22.5
4			22.5
Sheet2

Excel Workbook
	I	J	K	L
5	15			12
6	30			12
7
8
Joel McRae

 

[RLJ]

I did get it to work with the CTL+SHIFT+ENTER.

On a separate note, I tried to get to the site for the HTML maker to post like you did in the reply and it says that I do not have sufficient privilages to go the page for the download.

How do I get the privilages?

 

[Scott Huish]

If you are at a company, you will probably have to talk with your system administrator.