Thanks guys ,,, worked a treat , much obliged

"Toppers" wrote:

TRY:

=SUM(1/COUNTIF(A1:A5,A1:A5)*(B1:B5="France"))

Entered with Ctrl + Shift +Enter

Assumes no blanks in your data

"John Moore" wrote:

Hi guys, I am trying to use COUNTIF function to return data based on 2
criteria ...

A B C
1 12345 France 10
2 23456 UK 15
3 12345 France 20

What I am looking for is for the COUNTIF to return the number of orders for
FRANCE e.g. ( from the table above the answer would be 2 ) but, the problem I
ahve is that the order number ( column A ) is the same for rows 1 and 3 ,,,
so , effectively it's the same order , just different lines and qty's (
column C ) ,, so the answer I need is 1 ,,, is there a way to do this using
COUNTIF and perhaps VLOOKUP ?