Thread: Countif formula perhaps
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
  
Posts: 151
Default Countif formula perhaps
On 19/08/2012 10:36 AM, 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


Hi Howard

Your formula works for me using 2010, given that the Data1 is purely
digits 1 to 9. I changed it around and included 4 x 6's and a variety of
different combinations and it still worked for me.

What type of combination are you referring to, and when you say, "Not
Working", can you give an example of what the cell is displaying, if
anything.

HTH
Mick.
Reply With QuoteReply With Quote