I'm a newbe having problems with the functions IF and AVERAGE. I have a
spreadsheet with about 1322 rows. In Column "B" I have a value that
ranges from 0-10. In Column "D" I have numerical data.
I want to average only those rows in Column "D" that have a certain
value in Column "B". I created the following formula:
=AVERAGE(IF(B1:B1322=3,D1:D1322))
All it returns is the average of all the numbers in Column "D". What am
I doing wrong?
Thanks,
Tom
--
Cybertech
------------------------------------------------------------------------
Cybertech's Profile:
http://www.excelforum.com/member.php...o&userid=26533
View this thread:
http://www.excelforum.com/showthread...hreadid=398000