About Us

[email protected]

On Saturday, August 18, 2012 8:27:50 PM UTC-7, Living the Dream wrote:
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.

Hi Mick,
Thanks for the response

Here is a sample of entries for Data1. With 4 in the drop down cell P1 I would expect to return the value 5. =COUNTIF(Data1,P1) returns 0 (zero).

123456789 456 234
123 4 479
5 149 289

Howard

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED	Debbi	Excel Worksheet Functions	2	November 18th 09 04:47 AM
help in countif formula.	martin	Excel Discussion (Misc queries)	3	June 1st 06 10:21 AM
countif formula	archivesgirl	Excel Discussion (Misc queries)	3	February 25th 06 03:01 PM
CountIf formula results in the formula itself being displayed.	NewKid	Excel Worksheet Functions	9	December 21st 05 11:10 PM
Countif formula and then some...	Julie	Excel Worksheet Functions	6	July 27th 05 08:13 PM

Menu

About Us