Counting cells
 

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


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=390875

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)


"David494" wrote in
message ...

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


--
David494
------------------------------------------------------------------------
David494's Profile:
http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=390875