Calculate Average

[superkopite]

Hi guys and gals

I need to calculate some averages.

For example cells A1:A5 contain a +/-%, i need to be able the calculate the average of the percentages disregarding the + or -.

e.g, if A1= -3%, A2= -6%, A3= +5%, A4= +2% then the normal average would be -1%, but if you ignore the + and - then you get a return of 4%.

Now I know that i could put a formula into the adjacent cell to the effect of, if A1=>1 then *100 and covert to a regular number. But i have a lot of poages to write across alot of workbooks, so this would be a tad impractical.

Please tell me there is an easy way to do this

Cheers

James

[BigBas]

Use this array formula:

=AVERAGE(ABS(A1:A100))

Since it is an array formula, use CTRL+SHIFT+ENTER to confirm

[superkopite]

Praise be upon you BigBas.

That worked a treat!!!!

Cheers

James

[BigBas]

Glad I could help.