Hi Fiona,

Don't know if you are still monitoring this posting, but try this formula:

"=IF(COUNTIF(B1:B5,""x"")0,SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10&"""")),IF(C1=""x"",SUMPRODUC T(1/COUNTIF(A1:A10,A1:A10&"""")))
)"

John





"Fiona Yorke-Saville" wrote:

Hi

I wondered if anyone knew if I can add another condition to this formula.
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10&""))

I want to use the above formula if coloumn b contains c1

e.g

Coloumn A Coloumn B
1111 X
1111 X
1234 Y
1258 Z
1254 Y

I want to count Coloumn A (as detailed in the above formula) if Coloumn B
contains X (or cell C1)

Is that too many formulas?

Thanks