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?=average(if('test'!$E$2:$E$1048576>0;'test'!$E$2:$E$1048576))
Thanks in advance.
Bookmarks