Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for searching 3 different Criteria
A1 B1 C1
Location Hours Month Essex 6 November Kent 13 November Surrey 14 December Middlesex 24 January Essex 17 January Kent 12 January Essex 16 January Essex 21 January From the table above I need a formula that will filter out the location i want, total the number of hours for that location but only in a given month. For example in the table above i would be looking for a total number of hours spent in Essex but only those for January. The answer would therefore read 54. Answer would be in D1. Thanks in advance Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 a criteria in array of cells within an IF statement | Excel Worksheet Functions | |||
searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) |