Forum Discussion
Solved
Excel Formula
Can anyone help me with a formula? I've inherited one but it doesn't work & I'm pulling my hair out. I am trying to calculate the Avg.ValueofUsers.Per.Count -Example below Value Users...
In D25:
=SUMIFS($C$2:$C$22,$C$2:$C$22,">2500")/SUMIFS($D$2:$D$22,$C$2:$C$22,">2500")
In D26:
=SUMIFS($C$2:$C$22,$C$2:$C$22,">=500",$C$2:$C$22,"<=2500")/SUMIFS($D$2:$D$22,$C$2:$C$22,">=500",$C$2:$C$22,"<=2500")
In D27:
=SUMIFS($C$2:$C$22,$C$2:$C$22,"<500")/SUMIFS($D$2:$D$22,$C$2:$C$22,"<500")
Another approach to obtaining the counts is to use FREQUENCY. Versions of Excel supporting dynamic arrays may enter it as is and Excel will calculate. Older versions must input the formula as a multi-cell array: select three cells, input formula, ctrl+shift+enter.
=FREQUENCY(C2:C22,F2:F3)