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")
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")
- Hi Hans, many thanks for that - although I am trying to get the Average Value per count based on criteria in one formula
Can you provide an example of what you want?
- Hi Hans,
In this example, there is a
Count of 10 values <500.
Total Value = 5364.
There is a Total of 129 Users for each of the Values <500.
The figure I'm looking for is 42. (=5364/129)
All this to be calculated in D27 as one formula
