I have a column of colors:
White
Red
Yellow
Yellow
Black
Red
White
Red
Red
Black
Black
Black
White
White
White
Is there a formula for determining how many of each color appear in
the column?
Thanks in advance.
I have a column of colors:
White
Red
Yellow
Yellow
Black
Red
White
Red
Red
Black
Black
Black
White
White
White
Is there a formula for determining how many of each color appear in
the column?
Thanks in advance.
Hi
Try something like this:
=COUNTIF(A2:A2000,"White")
--
Andy.
"Ralph Smith" <[email protected]> wrote in message
news:[email protected]...
>I have a column of colors:
>
> White
> Red
> Yellow
> Yellow
> Black
> Red
> White
> Red
> Red
> Black
> Black
> Black
> White
> White
> White
>
> Is there a formula for determining how many of each color appear in
> the column?
>
> Thanks in advance.
Thank-you. I have two worksheets, "Data" and "Summary" the "Data"
sheet contains all the colors information. I would like to place this
formula in the "Summary" sheet.
How do I modify this formula so that it can show up in the summary
sheet?
Thanks again. I am very new to all this.
On Tue, 24 May 2005 17:14:49 +0100, <Andy B> wrote:
>Hi
>Try something like this:
>=COUNTIF(A2:A2000,"White")
Just add the name of the sheet
=COUNTIF(Data!A2:A2000,"White")
Alok Joshi
"Ralph Smith" wrote:
> Thank-you. I have two worksheets, "Data" and "Summary" the "Data"
> sheet contains all the colors information. I would like to place this
> formula in the "Summary" sheet.
>
> How do I modify this formula so that it can show up in the summary
> sheet?
>
> Thanks again. I am very new to all this.
>
>
> On Tue, 24 May 2005 17:14:49 +0100, <Andy B> wrote:
>
> >Hi
> >Try something like this:
> >=COUNTIF(A2:A2000,"White")
>
>
Thanks. Worked great.
On Tue, 24 May 2005 09:44:02 -0700, "Alok"
<[email protected]> wrote:
>Just add the name of the sheet
>
>=COUNTIF(Data!A2:A2000,"White")
>
>Alok Joshi
>
>"Ralph Smith" wrote:
>
>> Thank-you. I have two worksheets, "Data" and "Summary" the "Data"
>> sheet contains all the colors information. I would like to place this
>> formula in the "Summary" sheet.
>>
>> How do I modify this formula so that it can show up in the summary
>> sheet?
>>
>> Thanks again. I am very new to all this.
>>
>>
>> On Tue, 24 May 2005 17:14:49 +0100, <Andy B> wrote:
>>
>> >Hi
>> >Try something like this:
>> >=COUNTIF(A2:A2000,"White")
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks