Hello.
My question is about my formula:
I want to get average,min and max for all cells in column E (except E1 because its a header for table) without counting empty cells (because when i just put average or min,max without if its counting empty cell as 0 and calculations are not accurate, but zeroes can be counted). Is there any way to improve that formula?
Please Login or Register to view this content.
Thanks in advance.
for average try =AVERAGE(IF($E$2:$E$11<>"",$E$2:$E$11))
for min =MIN(IF($E$2:$E$11>0,$E$2:$E$11))
for max =MAX(IF($E$2:$E$11>0,$E$2:$E$11))
change the references as per the data !
array entered !
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hello hemesh!
Thanks for. I just changed range to $e:$e. Again thanks!Please Login or Register to view this content.
Last edited by teh.format; 02-24-2014 at 02:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks