Hello
I would like to get an average value H875 and H879 only, not H875 through H879.
AVERAGEIF(H875:H879,">0") is working perfectly but
AVERAGEIF(H875,H879,">0") is not working
Anyone could help me out? Thanks in advance!
From Rachel
Hello
I would like to get an average value H875 and H879 only, not H875 through H879.
AVERAGEIF(H875:H879,">0") is working perfectly but
AVERAGEIF(H875,H879,">0") is not working
Anyone could help me out? Thanks in advance!
From Rachel
Welcome to the forum!
Have you tried this?
=AVERAGEIFS(H875,">0",H879,">0") - may not work in your version
Or even just:
=AVERAGE(H875,H879)
Last edited by AliGW; 01-20-2019 at 07:09 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
or even just =(H875+H879)/2?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Yep - can't help thinking there's more to it that we have not yet been told ...
Wow! Thanks for a quick reply!
=AVERAGEIFS(H875,">0",H879,">0") is not working.
=AVERAGE(H875,H879) is working but I need to exclude zero. What I want to achieve is that if H875 = 0 and H879 = 70, the average is 70
From Rachel
Maybe this?
=AVERAGE(IF(H875=0,"",H875),IF(H879,0,"",H879))
Wow! It worked!
You are awesome! Thanks a lot for your great help
From Rachel
Great!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Just an FYI for future reference, this would also work...
=IF(H875=0,H879,IF(H879=0,H875,(H875+H879)/2))
this would cover it if you were dealing with blanks...
=IF(OR(H875=0,H875=""),H879,IF(OR(H879=0,H879=""),H875,(H875+H879)/2))
may have to adjust the parens but either should work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks