| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count values with conditions
Hi!
I have a sheet with 3 rows (A- date; B-first_name; C-last_name) - see http://users.kiss.si/~k4ef2308/images/1.jpg for screenshot. I would like to count a number of (for example) cells with values John (in row B ) Smith (in row C) for a certain period, let's say April (row A). I need a review for certain people and for certain period. See http://users.kiss.si/~k4ef2308/images/2.jpg for screenshot. How should I write formula? Tnx, Elvis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
| get a single count after looking up a set of values | Excel Worksheet Functions | |||
| How to count the number of 'values' in a cell | Excel Worksheet Functions | |||
| Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
Threaded Mode
