I'm trying to calculate a single average of 2 columns (ex: A1:A10 and B1:B10) using the higher of the 2 values per row.
So for example:
A B
5 7
2 2
4 8
5 5
7 4
2 2
4 6
8 9
3 4
3 1
The equation should take the average of 7, 2, 8, 5, 7, 2, 6, 9, 4, 3 and return 5.3.
Have you thought of insert a helper column?
I really don't want to have to use a helper column. If there isn't another way, so be it, but there has to be a way to make it work without one.
This is an array formula, you have to enter it with Ctrl + Shift + Enter.
Formula:
Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Thanks, that formula works.
However......
I have some blank cells in my actual data range (usually at the end of the range, but sometimes in the middle), and the formula is treating them as zeros instead of ignoring them. How can I fix that?
Last edited by DeZeeuw2; 03-12-2015 at 10:10 AM.
Maybe add another IF portion to test if a cell is blank or not?
Last edited by DeZeeuw2; 03-12-2015 at 10:09 AM.
Not sure how you want it so I included both alternatives.
Yep. Works Perfectly. The formula that still accepts numbers with an adjacent blank cell was what I needed. Thanks a lot!
**Marked thread as solved.**
''''''''
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks