| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average with specific criteria
I need to average the cells on column b that correspond to the criteria in
column a. If cells in column a match "EDCP", average the cells in column b that correspond to those cells, not the whole column. In this case it would equal 00:30. I will appreciate your help. Order Procedure Drawn to Received EDCP 0:06 CBCsD 0:06 UA 0:16 EDCP 0:59 CBCsD 0:59 Troponin-I 0:59 EDCP 0:25 -- Clari |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of 12 months data from a specific month | Excel Discussion (Misc queries) | |||
| average with 2 criteria | Excel Worksheet Functions | |||
| Calculate Average on specific items | Excel Worksheet Functions | |||
| Average Age of Population on a Specific Date | Excel Worksheet Functions | |||
| Average only with specific critera | Excel Discussion (Misc queries) | |||
Threaded Mode
