Count of Sum query.

[Marie123]

Here is my table. Is there anyway I can calculate How many Admin, fixed people there are in the South or How many Support, Mobile in the West with a formula. Each part is ina different coloum.

Admin / Support Fixed / Mobile Area
Admin Fixed South
Admin Mobile East
Admin Mobile West
Support Fixed Mid
Support Fixed East
Support Mobile South
Support Mobile South
Support Mobile West

[daddylonglegs]

You could use SUMPRODUCT, something like this

=SUMPRODUCT((A2:A100="Admin")*(B2:B100="Fixed")*(C2:C100="South"))

[Marie123]

You could use SUMPRODUCT, something like this

=SUMPRODUCT((A2:A100="Admin")*(B2:B100="Fixed")*(C2:C100="South"))

Thank you. Really helpful!