| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a column is criteria in two in column and other column are met
My formula:
=COUNT(IF(AND('Jan UA'!$C:$C,"ORD",'Jan UA'!$P:$P,M3),COUNT('Jan UA'!$P:$P))) I want to Count all the cells in column P when column C = ORD and column P = what is in M3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on Mulipple Criteria acrossed Column count last column | Excel Worksheet Functions | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Threaded Mode
