| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average If Statement (Excel 2003)
I am trying to find the formula for averaging cells in column B if the data
in Ais (a specific criteria). I've tried some formulas in the threads related to average, but nothing seems to work. Example: If A1:A110 equals 01 Then Average B1:B110 (cells related to the criteria in A1:A110) When using formulas, should cells have a specific format? Because there is text involved, I set the cell format to general. Do you suggest differently? Also, I'm working with data that I exported from a Microsoft Access 2007 database (SQL) but I'm using Excel 2003. Will this cause a problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement then Average | Excel Discussion (Misc queries) | |||
| excel 2003-countif statement | Excel Discussion (Misc queries) | |||
| Excel 2003 and AVERAGE function | Excel Worksheet Functions | |||
| Average Line - Excel 2003 | Charts and Charting in Excel | |||
| Average with more than one IF statement | Excel Worksheet Functions | |||
Threaded Mode
