ExcelBanter - count if with multi arguments

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count if with multi arguments (https://www.excelbanter.com/excel-worksheet-functions/123849-count-if-multi-arguments.html)

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!

count if with multi arguments

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

wrote in message
ups.com...
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!