| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average AM or PM values
ColumnA alternates between text "AM" and "PM"
ColumnC contains corresponding numbers/values I want two formulas to put in Column E: 1) Average "AM" values 2) Average "PM" values Should be simple, but I can't get it right. Any help? -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
| Conditional math using AND, Average | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
| How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
Threaded Mode
