A
Alan
Hi,
xl2007 formula "COUNTIFS" as following:-
=COUNTIFS('MTD Reach'!K:K,">0",'MTD Reach'!A:A,B12:B277)
*Criteria range 1 = 'MTD Reach' (Sales data)
*Criteria 1 = >0 (More than 0)
*Criteria range 2 = 'MTD Reach'!A:A (Range of source data)
*Criteria 2 = B12:B277(Data Match)
how to convert it to suit xl2000-2003 version
Regards
Alan
xl2007 formula "COUNTIFS" as following:-
=COUNTIFS('MTD Reach'!K:K,">0",'MTD Reach'!A:A,B12:B277)
*Criteria range 1 = 'MTD Reach' (Sales data)
*Criteria 1 = >0 (More than 0)
*Criteria range 2 = 'MTD Reach'!A:A (Range of source data)
*Criteria 2 = B12:B277(Data Match)
how to convert it to suit xl2000-2003 version
Regards
Alan