Formula for searching 3 criteria
=SUMPRODUCT(--(A2:A7="London"),--(C2:C7="February"),B2:B7)
Regards,
Stefi
€˛Craig€¯ ezt Ć*rta:
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
|