Prev: sumifs multiple columns help
Next: update vlookup formula sheet reference for multiple sheets
From: Tim JA on 12 May 2010 18:41
Thank you.. you were right it does work!!! I intially copied the formula
wrong. Thanks again.

"Ashish Mathur" wrote:

> Hi,
>
> That is exactly what my formula does. I have tried it. It will search for
> all occurrences of 2 in the range above (whether appearing in the cell alone
> or along with some other number). If there is more than 1 number in one
> cell, the numbers have to be segregated by commas (as shown in your initial
> post)
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
> www.ashishmathur.com
>
> "Tim JA" <TimJA(a)discussions.microsoft.com> wrote in message
> news:71586C06-4028-49A7-8EC7-681551921D4B(a)microsoft.com...
> > The formula you provided works for cells containing a single number. How
> > can
> > I get it to include a specific number in cells with multiple numbers as
> > well?
> > For example, if I wanted occurrences for the number 2... there's a cell
> > with
> > just that number by itself and another cell that has both 2 and 6. In this
> > case, the formula should come up with 2 occurrences...
> >
> > "Ashish Mathur" wrote:
> >
> >> Hi,
> >>
> >> Actually the simplest approach would be to use text to columns to
> >> segregate
> >> numbers in different columns and then use the countif
> >>
> >> =countif(A3:F50,A55)
> >> --
> >> Regards,
> >>
> >> Ashish Mathur
> >> Microsoft Excel MVP
> >> www.ashishmathur.com
> >>
> >> "Tim JA" <Tim JA(a)discussions.microsoft.com> wrote in message
> >> news:D88BC3C5-BA45-4860-B487-CA195D327E46(a)microsoft.com...
> >> > I'm using office 2007, specifically excel. I cannot get the countif
> >> > function
> >> > to accurately count cells containing multiple numbers. For example
> >> > below
> >> > is a
> >> > column containing both single and multiple numbers. I'm trying to get a
> >> > count
> >> > based on any number in the column. Perhaps, I'm using the wrong count
> >> > function. I've tried using wild cards... but to no avail. Your help
> >> > would
> >> > be
> >> > greatly appreciated.
> >> >
> >> >
> >> >
> >> > 5
> >> > 9
> >> > 2,6
> >> > 2
> >> > 3,6
> >> > 6,7
> >> > 5,13
> >> > 2
> >> >
> >> > 6
> >> >
> >> > 1,10,13
> >> > 13
> >> >
> >> .
> >>
From: Ashish Mathur on 14 May 2010 20:00
You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tim JA" <TimJA(a)discussions.microsoft.com> wrote in message
news:CCA691D6-1A18-40D8-9F03-1E0A72012FA7(a)microsoft.com...
> Thank you.. you were right it does work!!! I intially copied the formula
> wrong. Thanks again.
>
> "Ashish Mathur" wrote:
>
>> Hi,
>>
>> That is exactly what my formula does. I have tried it. It will search
>> for
>> all occurrences of 2 in the range above (whether appearing in the cell
>> alone
>> or along with some other number). If there is more than 1 number in one
>> cell, the numbers have to be segregated by commas (as shown in your
>> initial
>> post)
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>> www.ashishmathur.com
>>
>> "Tim JA" <TimJA(a)discussions.microsoft.com> wrote in message
>> news:71586C06-4028-49A7-8EC7-681551921D4B(a)microsoft.com...
>> > The formula you provided works for cells containing a single number.
>> > How
>> > can
>> > I get it to include a specific number in cells with multiple numbers as
>> > well?
>> > For example, if I wanted occurrences for the number 2... there's a
>> > cell
>> > with
>> > just that number by itself and another cell that has both 2 and 6. In
>> > this
>> > case, the formula should come up with 2 occurrences...
>> >
>> > "Ashish Mathur" wrote:
>> >
>> >> Hi,
>> >>
>> >> Actually the simplest approach would be to use text to columns to
>> >> segregate
>> >> numbers in different columns and then use the countif
>> >>
>> >> =countif(A3:F50,A55)
>> >> --
>> >> Regards,
>> >>
>> >> Ashish Mathur
>> >> Microsoft Excel MVP
>> >> www.ashishmathur.com
>> >>
>> >> "Tim JA" <Tim JA(a)discussions.microsoft.com> wrote in message
>> >> news:D88BC3C5-BA45-4860-B487-CA195D327E46(a)microsoft.com...
>> >> > I'm using office 2007, specifically excel. I cannot get the countif
>> >> > function
>> >> > to accurately count cells containing multiple numbers. For example
>> >> > below
>> >> > is a
>> >> > column containing both single and multiple numbers. I'm trying to
>> >> > get a
>> >> > count
>> >> > based on any number in the column. Perhaps, I'm using the wrong
>> >> > count
>> >> > function. I've tried using wild cards... but to no avail. Your help
>> >> > would
>> >> > be
>> >> > greatly appreciated.
>> >> >
>> >> >
>> >> >
>> >> > 5
>> >> > 9
>> >> > 2,6
>> >> > 2
>> >> > 3,6
>> >> > 6,7
>> >> > 5,13
>> >> > 2
>> >> >
>> >> > 6
>> >> >
>> >> > 1,10,13
>> >> > 13
>> >> >
>> >> .
>> >>
First  |  Prev  | 
Pages: 1 2 3
Prev: sumifs multiple columns help
Next: update vlookup formula sheet reference for multiple sheets