count if with multi arguments
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!
|