Hello,
I just want to get the average of one of my column (Column J) based on two criteria on the same column (Column BA).
The two criteria are:
I've used the below formula![]()
Column BA is not equal to VANILLA VOIP & VoIP Enterprise AND Column B is equal to CSM-1
![]()
Column Q = Score =AVERAGEIFS(Q:Q,BA:BA,"CSM-1",J:J,"<>VANILLA VOIP",J:J,"<>VoIP Enterprise")
Bookmarks