Counting cells

[David494]

Hey

I have a spreadsheet, which is connected to a SQL Server database. The
spreadsheet searches by date and then gets all the info between the two
dates and displays it on the worksheet.

I then sort all of the columns accending, but sorted by column 1. The
idea is to count the number of cells where for example "column 1 =
General Enquiry". To do this I scroll down, find all the General
Enquiry entries, select them all and then paste them into a new
worksheet, which gives the number of entries for that category type.

Is there a way to do this through perhaps using a button/interface?

Thanks everyone

Dave

 

[Bob Phillips]

You can do it with a formula

=COUNTIF(A:A,"General Enquiry")

or drop the data into a pivot table

--

HTH

RP
(remove nothere from the email address if mailing direct)