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
|