| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for searching 3 criteria
Can someone help me with this formula? I have a table that looks like this:-
A1 B1 C1 Location Hours Month London 6 January Manchester 14 January London 12 February London 11 February Birmingham 16 February London 9 February I want to count the hours for a single location but only in a certain month. For example if i need to count the total hours spent in london for february the answer would be 32. The answer would be returned in D1 Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for searching 3 different Criteria | Excel Discussion (Misc queries) | |||
| Searching for records with multiple criteria | Excel Worksheet Functions | |||
| Searching two columns against a specific criteria | Excel Worksheet Functions | |||
| Formula searching data that dose not equal two criteria | Excel Discussion (Misc queries) | |||
| searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) | |||
Threaded Mode
