Summarization AverageIf
jyotikumar
Forums
I have 90 Columns and I want the average of each column, but the only condition is to take the average of those whose values are more than 0. Like we do in Excel by using AverageIF(). How can this be done on IDEA?
IDEA has no special function
IDEA has no special function like @AVERAGEIF() or @SUMIF() however there's also no @SUM function. But that doesn't matter because the "Summarize fields" feature leads to the same result. You will find it in the ribbon menu, register "Analysis". There you can choose between Sum, Average and others.
https://ideascripting.com/forum/excel-sumif-formula-equivalent