Formula for average of any 2 cells out of 4 cells
i have 4 cells choosen, but only two of them it will have a value entered (could be any 2 of the four cells) , how can Imake a formula displaying the average of the 2 value entered disregarding the other 2 cells (empty or with a pre determined valueo of "zero")
Hope you can help
Thanks
Hi and welcome to the forum
Try
=AVERAGEIF(A1:A4,">0")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis , the formula works perfectly , but there is way for the cell with the formula to stay blank while no value was entered yet in the fields, without displaying DIV/0! .. ?
Thanks
=IFERROR(fotis's_formula,"")
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Yes there is.
=IFERROR(AVERAGEIF(A1:A4,">0"),"")
Thanks man !!!!
You are welcome.
Pls mark your thread as Solved(See at the top of the page to see how to do this)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks