I was trying to apply AVERAGE(A1:A3,"<>0") formula in Excel to the Multi-Row Formula Tool to exclude zero in the average function, but all attempts failed.
Can someone please help with this? THANK YOU!
@Jeyez Can you please upload some dummy data so we could test it?
I'm not sure why you need a Multi-row tool but in the Summarize tool, you can actually choose "Numeric" option and get the "Average without 0s".
Otherwise, as @Prometheus says, kindly provide the following: