#### Kihoro

##### New member

hi guys,:nod:

please find attached worksheet - test1

Am trying to have the formula in c31 sum and calculate the

Average of any last three numbers in range f25:bi25.

I have a formula in cells range AL25:BI25 (=IF(AL4>0,(AL4-AK4)/AK4,"")

That will calculate the percentage as long cell AL4 is greater than zero.

The formula in CI is supposed to calculate the average of the last three numbers while ignoring

The formula in the cell AL25:BI25. The formula returns a #VALUE error

How do I go round this problem?

I want the formula in CI to ignore the formula in cell range AL25:BI25 and just compute the average of the last three numbers only..

thanks alot in advance

please find attached worksheet - test1

Am trying to have the formula in c31 sum and calculate the

Average of any last three numbers in range f25:bi25.

I have a formula in cells range AL25:BI25 (=IF(AL4>0,(AL4-AK4)/AK4,"")

That will calculate the percentage as long cell AL4 is greater than zero.

The formula in CI is supposed to calculate the average of the last three numbers while ignoring

The formula in the cell AL25:BI25. The formula returns a #VALUE error

How do I go round this problem?

I want the formula in CI to ignore the formula in cell range AL25:BI25 and just compute the average of the last three numbers only..

thanks alot in advance