Good morning from ATL,
Is there a way to get an average but ignoring #DIV! errors? Values are in non-consecutive cells so I can't use range formula like AVERAGEIF(D2:L2, "<>#DIV/0!"). Values are in D2,H2,L2.
Good morning from ATL,
Is there a way to get an average but ignoring #DIV! errors? Values are in non-consecutive cells so I can't use range formula like AVERAGEIF(D2:L2, "<>#DIV/0!"). Values are in D2,H2,L2.
How aboutFormula:Please Login or Register to view this content.
does this work
=AGGREGATE(1,6,D2,H2,L2)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Why is an average of an average usually incorrect?
https://math.stackexchange.com/quest...ally-incorrect
Last edited by popipipo; 01-29-2022 at 12:43 PM. Reason: edit file
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
They Worked!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks