| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel-only average cells if two cells in same row, meet two condit
I want to average only some of the values in a column, based on tests on
other cells in the same row. For example: Suppose I have numeric values in A1:A10 and alpha characters in columns B1:B10 and C1:C10. If the value in cell B1="ORD" and the value in cell C1="MIA" then use the numeric value in cell A1 in the average. If these two conditions are not TRUE then treat cell A1 as blank. I want this same check to apply to each row. So I want to average only the An cells that meet this condition. Can anyone help me code this function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only cells that contain numbers | Excel Worksheet Functions | |||
| omiting cells in average calcs | Excel Discussion (Misc queries) | |||
| Excel 2003, which formula will count the cells that meet 2 conditi | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
