I'm having trouble getting a formula to work that will average numbers in a column while excluding some data based on the data in another column.
I think I'm having trouble because I'm seeing some formulas startout with =AVERAGEIF and others starting out with =AVERAGE(IF ...
[Well, to be honest, since I can't get either approach to work, maybe that isn't the problem.]
Anyway, here's the situation:
- I want to average some of the numbers that appear in column AC (data in cells AC2:AC148)
- I want to exclude any numbers that correspond to rows that have an "y" in F2:F148.
Thanks in advance for your time.
Bookmarks