Selected Answer
Fida
The COUNTIFS function will work for this but remember that it gives a 1 every time all criteria pairs are met- your formula in H2:
=COUNTIFS($D:$D,"Type 1",$C:$C,"Africa",$D:$D,"Type 2",$C:$C,"Africa")
needs cells in column C to be "
Africa" but in column D to be both "
Type 1" and "
Type 2" (so you get 0 since D is either Type 1 or 2).
You need to add two COUNTIFS like this (for H2 again) like this:
=COUNTIFS($D:$D,"Type 1", $C:$C,"Africa") + COUNTIFS($D:$D,"Type 2", $C:$C,"Africa")
so you count the matches for Africa and Type 1 first and then again but for Type 2.
In the attached file, I've done the formulae for H2:K2.
Note that you can have multiple criteria per column (which will AND togther for the puposes of counting). For example in column 0 of the attached file, you'll see some numbers in column O and in cell O14, the formula:
=COUNTIFS(O3:O12, ">=" & 7,O3:O12, "<=" & 14)
allows us to count how many numbers are between 7 and 14 say. Note the bits in bold above (where arithmetic operators are within inverted commas) - when you're in cell 014, use the
fx button to left of the formula bar) to get help on the syntax of the function via the "
Help on this function" hyperlink.
Hope this is clear.