Summarization AverageIf

2 posts / 0 new
Log in or register to post comments
Last post
Tue, 10/11/2022 - 02:53
#1
jyotikumar
Offline
Joined: 04/08/2022 - 02:37
Summarization AverageIf

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?

Top
Thu, 10/13/2022 - 04:35
klmi
Offline
Joined: 02/13/2019 - 08:41

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

Top