count if with multi arguments

G

GABRIELA_GIL

A B C
1 PHASE LOCTION OWNER
2 OKAY L 1 - Q 1 Dorothy 1
3 CHECK L 1 - Q 2 Allan 1
4 OKAY L 1 - Q 5 Xavier 1
5 OKAY L 1 - Q 5 Xavier 1
6 EMRFAIL L 1 - Q 5 Xavier 1
7 EMRFAIL L 2 - Q 5 LOUIS
8 OKAY L 3 - Q 1 NATHAN
9 OKAY L 3 - Q 2 BETTY
10 OKAY L 3 - Q 2 BETTY
11 OKAY L 3 - Q 3 ERIC


* I am trying to sum up all of the phases by location.... can any one
help? thanks!
 
T

Trevor Shuttleworth

You can either use a Pivot Table or a number of SUMPRODUCT formulae, for
example:

=SUMPRODUCT((A1:A11="OKAY")*(B1:B11="L 1 - Q 5"))

Regards

Trevor
 
Top