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