Counting with 2 criteria

[subwayheaven]

http://img515.imageshack.us/img515/4921/14873395.png

Check that picture to see what I'm talking about

I need a formula that will count how many part time staff (PART) that live in the north west (NWest).

D141 simply uses a COUNTIF statement to count how many PART's there are in column D using the following formula;

=COUNTIF(D14:D36,"PART")

I think that cell is fairly useless ether way.

Please help

Thanks In advance, Dave

[ChemistB]

Please Login or Register  to view this content.

Does that work for you? Alternately, Select cells to put your values into , e.g. H1 and I1 and set up the formula like so

Please Login or Register  to view this content.

[HammerTime]

ChemistB

Can you please explain what the "--" infront of the array does?

[ChemistB]

The "-" is called the unary operator (or negation operator). The expression (for example) $D$2:$D$200="Part" will give "True", "False" values. A "-" in front of it negates it and forces excel to see it as a number (0 = False, 1 = True). The double unary converts the value back to the original. So basically, the -- changes True to 1 and False to 0. Hopefully that's clear?

[Jack in the UK]

ChemistB

Can you please explain what the "--" infront of the array does?

Look at it as if it makes excel count - which is really what you want here

[subwayheaven]

Cheers guys, Works great, just edited the absolute values a bit, and it worked fine

You helped out a lot, Well done.