A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How many in column



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2005, 05:14 PM
external usenet poster
 
Posts: n/a
Default

Hi
Try something like this:
=COUNTIF(A2:A2000,"White")

--
Andy.


"Ralph Smith" wrote in message
...
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.



  #2  
Old May 24th, 2005, 05:16 PM
Ralph Smith
external usenet poster
 
Posts: n/a
Default How many in column

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.
  #3  
Old May 24th, 2005, 05:37 PM
Ralph Smith
external usenet poster
 
Posts: n/a
Default

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")


  #4  
Old May 24th, 2005, 05:44 PM
Alok
external usenet poster
 
Posts: n/a
Default

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")



  #5  
Old May 24th, 2005, 06:11 PM
Ralph Smith
external usenet poster
 
Posts: n/a
Default

Thanks. Worked great.

On Tue, 24 May 2005 09:44:02 -0700, "Alok"
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")




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to group similar column titles together???? vrk1 General Discussion 2 April 30th, 2005 12:17 AM
Table Design A. Williams Database Design 3 April 29th, 2005 07:02 PM
up to 7 functions? ALex Worksheet Functions 10 April 12th, 2005 06:42 PM
How can I sort an entire spreadsheet from a list prod sorter Worksheet Functions 4 November 17th, 2004 04:43 AM
Macro Fill Down - filling too much of the column Greegan Worksheet Functions 1 September 20th, 2004 02:48 AM


All times are GMT +1. The time now is 12:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.