| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
I have several drop down menus on sheet 1 with employee names in column H
is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif within a filtered sheet | New Users to Excel | |||
| Countif using the same cell on every sheet | Excel Worksheet Functions | |||
| Countif on two columns in a sheet | Excel Discussion (Misc queries) | |||
| Using CountIf with criteria on another sheet? | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Threaded Mode
