Thread
:
Average If
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Average If
This is an ARRAY formula that must be entered using ctrl+shift+enter
=AVERAGE(IF((A2:A1075),B2:B10))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"carl" wrote in message
...
Is it possible to compute an average given a criteria.
For example, I have some data like this:
30 Day High30 Day Vol
267.22 46.11
79.24 35.29
26.24 68.58
42.39 58.24
53.94 48.04
70.70 34.96
151.13 41.55
32.77 23.85
30.87 27.88
I wanted to compute an average of ColB if ColA was equal to or greater
than
75.
In this case, the average would be 40.98
Thank you in advance.
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]