| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurrents based on criteria in different column
Look at Data in D & E. If blank, and if column C = "studio", then count
occurrences. C D E Studio Allen Barnes Private Jones Studio Double Hayes Hayes Studio Taylor In this case, the answer should be (3). OR, IF POSSIBLE, would like to look at blanks, and deliver totals of C, i.e. Studio = 3, Private = 1 Also, would it be possible to look at multiple sets of columns, Look at D, E, H, I and deliver summary from C and G? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT based on 2 criteria | Excel Worksheet Functions | |||
| Count based on criteria | Excel Discussion (Misc queries) | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Threaded Mode
