| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with IF & Average Functions
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
| MIN, MAX, AVERAGE functions | Excel Worksheet Functions | |||
Threaded Mode
