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