On 2002-08-26 11:34, alphazero wrote:
Ok. THanks a lot.
I have another formula I am trying to get working:
=COUNTIF(AVERAGE(F23:F31), B5)
Basically, I want to get the average of a group of numbers... but only include the numbers associated with the value of "B5". I keep getting a message that I have an error... but can't see what is wrong with the above formula.
On 2002-08-26 12:09, alphazero wrote:
Yes. You're right.
B5 should be associated with the values B23:B31. If any values between those cells matches B5, then the value in the associated cells F23:F31 should be included in the Average. How do I change my formula to make this work?
Book4 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Nums | Ids | Aveof'a' | |||
2 | 1 | a | 1.5 | |||
3 | 2 | a | ||||
4 | 3 | b | ||||
5 | 4 | b | ||||
6 | ||||||
Sheet1 |