Dependent counting

Hi

I want to be able to count the entries in a column dependent on the entry in another column.

In my example attached column A7 counts how many times Direct UK appears. A8 counts how many times Direct HK appears.

What I now want to do is count the number of times dates appear in column B for Direct UK to present in A10 and the number of times dates appear in column B for Direct HK to present in A11.

The answers I am expecting back are A10 = 2 and A11 = 1

I'm sure this is easy but its not for me.

Thanks

Lee

B8=SUMPRODUCT((B2:B6="direct UK")*(C2:C6<>""))

Sure you can work the other one out yourself...

HTH

Thanks very much!!

Could I layer this again by making it dependent on a third column.

e.g. New and Rebuy

Thanks

Lee

I'm thinking...
=SUMPRODUCT((B2:B6="direct UK")*(C2:C6<>"")*(d2:d6="new"))

Mark the thread as solved, if it is of course!

HTH