On Saturday, August 18, 2012 5:36:59 PM UTC-7, (unknown) wrote:
Excel 2010



Whe



Data1 is a named range of nine cells. The values in each cell of Data1 will always be 1 to 9 or a combination of numbers 1 to 9 and each cell will have no duplicates. And each cell could have just 1 number or perhaps three or all 9.



P1 is a cell with a Data Validation drop down list of numbers 1 to 9.



In a separate cell I have used =COUNTIF(Data1,P1) to count the number times the P1 value occurs in Data1. It does not work.



Can you suggest a formula to do this?



Thanks.

Regards,

Howard



On Saturday, August 18, 2012 5:36:59 PM UTC-7, (unknown) wrote:
Excel 2010



Whe



Data1 is a named range of nine cells. The values in each cell of Data1 will always be 1 to 9 or a combination of numbers 1 to 9 and each cell will have no duplicates. And each cell could have just 1 number or perhaps three or all 9.



P1 is a cell with a Data Validation drop down list of numbers 1 to 9.



In a separate cell I have used =COUNTIF(Data1,P1) to count the number times the P1 value occurs in Data1. It does not work.



Can you suggest a formula to do this?



Thanks.

Regards,

Howard

Whoops, six is the correct numbrer, I missed one!

Thanks everyone, I'll give it a go.

Regards,
Howard