Hello!
Could anyone tell me how to calculate an unsigned mean value - i.e. not taking into account whether a value is positive or negative?
Thanks,
TCG
Hello!
Could anyone tell me how to calculate an unsigned mean value - i.e. not taking into account whether a value is positive or negative?
Thanks,
TCG
Try this array formula. Enter with Ctrl + Shift + enter
VBA Noob=AVERAGE(ABS(A1:A6))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Belated thanks for your help, VBA Noob!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks